Binding an array to an input variable in OCI

From: Bruce Collie <bruce_at_oorclan.co.uk>
Date: Sat, 03 Sep 2005 21:12:43 +0100
Message-ID: <431a0f9b$0$22946$ed2619ec@ptn-nntp-reader01.plus.net>

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 Received on Sat Sep 03 2005 - 15:12:43 CDT