Originally posted by slimdave
You're missing a quote before other_Param, but that might just be a forum typo?

Perhaps you could change the CHAR declarations to varchar2, just to see what that does.
Yeah, that missing quote is a typo. And I tried to change that to varchar2, still got the same error

Any other thoughts?

Millions of thanks!