Re: "expecting string, unicode or buffer object" on executemany

Hello Ricardo,

Can you send a sample insert statement (unicode)  similar to one you are 
using.
Also can you inform which python/ cx-oracle and oracle version you are 
using.

Best Regards,
Avinash
On 9/23/2014 5:32 PM, Oliosi Riccardo wrote:
>
> Hello everybody,
>
> I have a strange error:
>
> When I call:
>
> cursor.executemany( self.__sql, self.__buffer )
>
> where
>
> self.__sql is an insert statement (unicode) and self.__buffer is a 
> list of tuple,  the execution throws an exception with  the following 
> message:
>
> "expecting string, unicode or buffer object"
>
> But if I substitute the executemany with a cycle:
>
> for item in   self.__buffer:
>
> cursor.execute(self.__sql, item)
>
> the script works without any problems.
>
> Can anyone help me?
>
> Thanks in advance.
>
> Riccardo
>
> ______________________
>
> *Riccardo Oliosi*
>
> SIDFramework
>
> /Gruppo CAD IT/
>
> Tel. +39.045.82.11.111
>
> Fax +39.045.82.11.110
>
> [email protected] <mailto:[email protected]>__
>
> www.cadit.it <http://www.cadit.it/>__
>
> *CAD IT S.p.A.*
>
> Sede legale: Via Torricelli, 44/A - 37136 Verona
>
> C.S. EUR 4.669.600,00 i.v.
>
> C.F./P.IVA e n. iscr. R.I. di VR 01992770238
>
> R.E.A. di VR n. 210441
>
> ______________________
>
> Questo messaggio, con gli eventuali allegati, contiene informazioni 
> riservate o confidenziali. Chiunque lo ricevesse pur non essendone il 
> destinatario è pregato di segnalarlo immediatamente al mittente, di 
> cancellarlo dal proprio sistema e di non copiarlo, diffonderne il 
> contenuto o utilizzarlo in alcun modo.
>
> This e-mail and any files transmitted with it are confidential or 
> privileged. If you are not the intended recipient of this e-mail, 
> please notify the sender and delete it from your system immediately: 
> you should not copy, disclose or use either it or its attachments in 
> any way whatsoever.
>
>
>
> ------------------------------------------------------------------------------
> Meet PCI DSS 3.0 Compliance Requirements with EventLog Analyzer
> Achieve PCI DSS 3.0 Compliant Status with Out-of-the-box PCI DSS Reports
> Are you Audit-Ready for PCI DSS 3.0 Compliance? Download White paper
> Comply to PCI DSS 3.0 Requirement 10 and 11.5 with EventLog Analyzer
> http://pubads.g.doubleclick.net/gampad/clk?id=154622311&iu=/4140/ostg.clktrk
>
>
> _______________________________________________
> cx-oracle-users mailing list
> cx-oracle-users-5NWGOfrQmneRv+LV9MX5uipxlwaOVQ5f@public.gmane.org
> https://lists.sourceforge.net/lists/listinfo/cx-oracle-users

------------------------------------------------------------------------------
Meet PCI DSS 3.0 Compliance Requirements with EventLog Analyzer
Achieve PCI DSS 3.0 Compliant Status with Out-of-the-box PCI DSS Reports
Are you Audit-Ready for PCI DSS 3.0 Compliance? Download White paper
Comply to PCI DSS 3.0 Requirement 10 and 11.5 with EventLog Analyzer
http://pubads.g.doubleclick.net/gampad/clk?id=154622311&iu=/4140/ostg.clktrk

_______________________________________________
cx-oracle-users mailing list
cx-oracle-users-5NWGOfrQmneRv+LV9MX5uipxlwaOVQ5f@public.gmane.org
https://lists.sourceforge.net/lists/listinfo/cx-oracle-users