Binding an array to an input variable in OCI

Hi,

I want to bind an array to the following sql statement using oci

SELECT UUID FROM TEST WHERE TYPE=:VAL

UUID is INTEGER
TYPE is CHAR(1)

If i use obndrv it only ever seems to use the first value in the array.
If i use obindps (which i've not used before) i cannot seem to get the
parameters correct, i get various different errors.

Does anybody know what is going wrong?
Any chance of a code sample for this?

Thanks
Bruce Collie

re: Binding an array to an input variable in OCI

CHapter 5 of Oracle's document "Oracle Call Interface Programmer's Guide"
is all about binding. Includes a section on binding with arrays and has
examples.

http://download-west.oracle.com/docs...bnd.htm#420516

You might want to switch to the officially chartered group
'comp.databases.oracle.server'. (As compared to this one that was
created as a result of a typo - 'database' instead of 'databases'.)
Non-chartered groups are not carried by many news providers so you are
missing a lot of possible support people.

--
Hans Forbrich
Canada-wide Oracle training and consulting
mailto: Fuzzy.GreyBeard_at_gmail.com
*** I no longer assist with top-posted newsgroup queries ***