Re: [cx-oracle-users] blob insert

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

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

Oh, ok, I thought you said you were having issues with insert.

I think instead of clob.open() you should use clob.read() something like...

clob_data = clob.read()

(I thought you were referencing blob data.)  Anyway, I'm certainly no
expert on cx_Oracle (or python), but have been using these particular
pieces of code (insert/read) for over a year now and it seems to work.

- -Jared

On 07/08/2009 12:30 PM, d' Ariel wrote:
> Let see, i don't understand you.
> 
> I'm executing a simple code:
> 
> import cx_Oracle
> 
> conection = cx_Oracle.connect('user/pass@<server:port>/session')
> cursor = connection.cursor()
> cursor.execute("select data from <sometable> where id = <some existing id>")
> clob, = cursor.fetchone()
> clob.open()
> 
> and i get an ORA-22292 error (not able to open an read-write lob
> whitout a transaction)
> any idea???
> 
-----BEGIN PGP SIGNATURE-----
Version: GnuPG v1.4.9 (GNU/Linux)
Comment: Using GnuPG with Mozilla - http://enigmail.mozdev.org/

iEYEARECAAYFAkpUzWEACgkQu4z7XptgTUZhVQCcCL2eOykqGIBP2rx9g2HSj5C3
XYQAn230i0VNBHE1lJPgb9wjXP7fNPCk
=PaPe
-----END PGP SIGNATURE-----