Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.misc -> Bind an array with OCI

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@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 - 07:15:57 CST

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US