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

[Amaury F. d'A. <ama...@gm...>]

2011/11/30 Wong Wah Meng-R32813 <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