Re: [cx-oracle-users] blob insert

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

Hello,

2009/7/8 d' Ariel <gn...@gm...>:
> 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???

I suggest to remove the call to clob.open(), and call
    clob.read()
directly.

-- 
Amaury Forgeot d'Arc