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

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

Yes I thought of this. I will convert the empty list [] as string and store it into the column. :)

Regards,
Wah Meng
________________________________
From: Amaury Forgeot d'Arc [mailto:ama...@gm...]
Sent: Wednesday, November 30, 2011 9:08 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...>>
SQL> Select attr_value from mes_attribute_histories where entity_type='ALOT' and attr_name='wipRack';

........
........
........
.......
KTMTEST:KT06
[]
[]
KTMPQCIL:KPQ03
[]
KTMQA:KQ01
[]
[]
[]


So, use str() and your list will be converted into a string :-)

--
Amaury Forgeot d'Arc