Binding an array to an input variable in OCI

Question posted by: Bruce Collie (Guest) on June 27th, 2008 07:01 PM

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

Would you like to answer this question?
Sign up for a free account, or Login (if you're already a member).

HansF

Guest

n/a Posts

June 27th, 2008
07:01 PM
#2

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/doc...5bnd.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 ***

Not the answer you were looking for? Post your question . . .
182,319 Experts ready to help you find a solution.
Sign up for a free account, or Login (if you're already a member).

Didn't find the answer you were looking for?
Post Your Question

Top Community Contributors