where x in (array)

[GNiessen]

I am looking to be able to do a select from a table using a "where ColA in A)', where A is a variable array.

Can you provide an example? I have tried a few things, but no success yet. And I would prefer not to dynamically create the SQL, but rather pass a parameter.

------------------
Gordon

 

[Marco Kalter]

You cannot use an array for this bind variable. You can only use a substitution variable and set its value to the corresponding expresssion:

DeclareVariable('A', otSubst);
SetVariable('A', '1,2,4,8');
...

------------------
Marco Kalter
Allround Automations

 

[toddbarry]

Another option is to use object types. This has worked very well for us.
http://asktom.oracle.com/pls/ask/f?p=4950:8:::::F4950_P8_DISPLAYID:110612348061