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_at_ptn-nntp-reader01.plus.net>
Hi,
Date: Sat, 03 Sep 2005 21:12:43 +0100
Message-ID: <431a0f9b$0$22946$ed2619ec_at_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 - 22:12:43 CEST