Re: [cx-oracle-users] Oracle Error :: ORA-01484 arrays can only be bound to PL/SQL statements

[Wong W. Meng-R. <r3...@fr...>]

Yes worst case is we will have to modify this SQL statement.

However, is it a long standing issue with Oracle or cx_Oracle? This is an old code and the passing of parameters in such way has been working fine on oracledb. So is this something the cx_Oracle does not support? IF it is oracle issue I wonder whey it did not give the error when we use oracledb.

Regards,
Wah Meng
________________________________
From: Amaury Forgeot d'Arc [mailto:ama...@gm...]
Sent: Wednesday, November 30, 2011 9:06 PM
To: cx-...@li...
Subject: Re: [cx-oracle-users] Oracle Error :: ORA-01484 arrays can only be bound to PL/SQL statements

2011/11/30 Wong Wah Meng-R32813 <r3...@fr...<mailto:r3...@fr...>>
>> cmd = "select ........ from FUTURE_HOLD_CONDITIONS where STEP_NAME not in (:1) and LOT_ID = :2 and ......."

This cannot work with Oracle. A placeholder can only replace one value.
(Think of the IN operator as a sequence of OR conditions)
Yes, this is a long standing issue with Oracle.
I suggest to try with %s formatting.

--
Amaury Forgeot d'Arc