Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
![]() |
![]() |
Home -> Community -> Usenet -> c.d.o.server -> Binding an arbitrary number of arguments
I'm trying to generate a dynamic SELECT query that has an arbitrary number of arguments using C++ and OCI 7.3. The query has the following form:
SELECT COLUMN1
FROM TABLE1
WHERE COLUMN2 IN (:A, :B, :C, ... );
The COLUMN2 value must be contained in the corresponding list (A, B,
C, ...). This list will contain an arbitrary number of values that are
not available when the query is generated. Is there a way to bind that
list of values to a C++ array? Or is there some other approach that
will work?
Thanks in advance,
Todd Noel
Sent via Deja.com http://www.deja.com/
Before you buy.
Received on Thu Sep 14 2000 - 14:22:25 CDT
![]() |
![]() |