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 -> an IN clause with a bind variable

an IN clause with a bind variable

From: Scott Patterson <scott.patterson_at_trilogy.com>
Date: Tue, 25 Aug 1998 14:28:02 -0700
Message-ID: <35e31038.0@feed1.realtime.net>


What is the trick to using a bind variable with an IN clause?

If I assign 3, 5, 7, 10 to :1 and parse the following statement is parses correctly but give the error ORA-01722 (invalid number) upon execution.

SELECT col1 FROM table1 where col1 IN (:1);

All the other SQL statements are working fine. It is only failing when there is an IN clause.

Thanks,

Scott

Details:
C program making OCI calls
Oracle 7.3.4
DEC Unix Received on Tue Aug 25 1998 - 16:28:02 CDT

Original text of this message

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