Hi,

Had a query in Oracle Call Level Interface,

In a typical query Select <field1> from <table> where <field2> = :1,
to the place holder :1 we can't bind in bulk as in values of an array
like {1,2,3,4}, well if we do bind what we get is only the first value
from table say the row containing 1.

The same thing when i put it as a nested subquery of update , like say

update <table2> set <field3> = :1 where <field4> = (Select <field1>
from <table> where <field2> = :2 ). To the place holder :2 if i do
bulk binds surprisingly i am able to do bulk updates.


-Kalyan