Re: [cx-oracle-users] blob insert

[Jared G. <jar...@or...>]

-----BEGIN PGP SIGNED MESSAGE-----
Hash: SHA1

I believe you need to use the Cursor.setinputsizes method to setup the
sql properly before the call.  For example, I have a script that uses
CLOB type (similar to BLOB) and the first thing I do before actually
executing the SQL is the following...

self.cursor.setinputsizes(description=cx_Oracle.CLOB)

Where self.cursor is my Cursor object and description is the name of the
bindvar used in the SQL code that I'm executing.

- -Jared

On 07/07/2009 06:00 PM, d' Ariel wrote:
> i was trying to insert a binary file (an image) into a table in an
> oracle database, everything goes well inserting another values, but
> when i try to insert a blob i get an error that the operation must be
> into a transaction.
> 
> I ask to Google but i didn't find any interesting result. Can someone
> help me. An inserting blob program will be usefull, thanks.
> 
> 
-----BEGIN PGP SIGNATURE-----
Version: GnuPG v1.4.9 (GNU/Linux)
Comment: Using GnuPG with Mozilla - http://enigmail.mozdev.org/

iEYEARECAAYFAkpUF/UACgkQu4z7XptgTUZh3QCfZmsHwSez9uPgdOgBJcdvwT0N
dWwAnjUH7TjtDogncAKKDyCkW2+fjYNS
=FX7U
-----END PGP SIGNATURE-----