Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.server -> Host variable in IN clause?

Host variable in IN clause?

From: Richard Murphy <rmurphy_at_lbpc.com>
Date: Thu, 31 Dec 1998 12:06:07 -0600
Message-ID: <368BBD0F.5E275D8@lbpc.com>


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

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US