Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
![]() |
![]() |
Home -> Community -> Usenet -> c.d.o.misc -> Bind an array with OCI
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
![]() |
![]() |