Re: [cx-oracle-users] Oracle Error :: ORA-01484 arrays can only be bound to PL/SQL statements
Brought to you by:
atuining
Menu
▾
▴
Re: [cx-oracle-users] Oracle Error :: ORA-01484 arrays can only be bound to PL/SQL statements
|
From: Christopher J. <chr...@or...> - 2011-12-02 19:39:47
|
On 12/01/2011 02:43 AM, Wong Wah Meng-R32813 wrote: > It looks like we have no other way except to change our SQL not to use statements like "in (:1)"? Correct, as others have said. The bind variable is only ever treated as a single piece of anonymous data by the Oracle DB. Tom Kyte has some discussions on "Varying IN Lists" in an old article http://www.oracle.com/technetwork/issue-archive/2007/07-mar/o27asktom-084983.html I cover the same topic a bit from from the binding perspective in PHP on page p146 of http://www.oracle.com/technetwork/topics/php/underground-php-oracle-manual-098250.html -- Email: chr...@or... Tel: +1 650 506 8630 Blog: http://blogs.oracle.com/opal/ |
