Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.server -> Host variable in IN clause?
Trying to use a host variable in a ProC program in a Where field IN
:hostVar statement.
Tried all sorts of mutations of this statement. The variable holds a
string of codes ex. "1359,2345,6789" or "'1359','2345','7689'"and the
field is a numeric field. I've tried converting the field to char,
enclosing the numbers in single quotes, etc. but with no luck.
Does someone know the syntax for what i am trying to do.
Thanks, Richard M. Received on Thu Dec 31 1998 - 12:06:07 CST