Re: [cx-oracle-users] blob insert
Brought to you by:
atuining
From: d' A. <gn...@gm...> - 2009-07-08 17:18:32
|
solved thanks. 2009/7/8 Amaury Forgeot d'Arc <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 > > ------------------------------------------------------------------------------ > Enter the BlackBerry Developer Challenge > This is your chance to win up to $100,000 in prizes! For a limited time, > vendors submitting new applications to BlackBerry App World(TM) will have > the opportunity to enter the BlackBerry Developer Challenge. See full prize > details at: http://p.sf.net/sfu/Challenge > _______________________________________________ > cx-oracle-users mailing list > cx-...@li... > https://lists.sourceforge.net/lists/listinfo/cx-oracle-users > -- Paz, Amor Y Empatia ----------------------- Ariel Hernandez Amador Gnu/LiNUX user: #354782 |