469,090 Members | 1,082 Online
Bytes | Developer Community
New Post

Home Posts Topics Members FAQ

Post your question to a community of 469,090 developers. It's quick & easy.

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


Sep 3 '05 #1
1 5377

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 ***

Sep 3 '05 #2

This discussion thread is closed

Replies have been disabled for this discussion.

Similar topics

1 post views Thread by JD Kronicz | last post: by
30 posts views Thread by lgbjr | last post: by
5 posts views Thread by Chuck Anderson | last post: by
9 posts views Thread by Miro | last post: by
1 post views Thread by Bruce Collie | last post: by
1 post views Thread by CARIGAR | last post: by
reply views Thread by zhoujie | last post: by
reply views Thread by kglaser89 | last post: by
By using this site, you agree to our Privacy Policy and Terms of Use.