Bind an array with OCI
From: Eric Arrigo <arrigo_at_systar.fr>
Date: Thu, 27 Jan 2000 14:15:57 +0100
Message-ID: <86pgh0$iv8$1_at_minus.oleane.net>
Hi,
Date: Thu, 27 Jan 2000 14:15:57 +0100
Message-ID: <86pgh0$iv8$1_at_minus.oleane.net>
Hi,
I'm trying to bind an array to a placeholder in a simple OCI query like:
"select * from foo where bar in :ph"
I want to bind ':ph' to a memory array filled with values of bar I need to
get.
I try without success to use obndra, and get an ORA-01414 error (Invalid
array length when trying to bind array).
Does anyone know if it is possible to make this without use PL/Sql ?
Any info about this would be greatly appreciated.
Eric. Received on Thu Jan 27 2000 - 14:15:57 CET