How to free a temporary clob in DCOracle2?
sholden at holdenweb.com
Mon Apr 14 15:58:27 CEST 2003
"Daniel" <dl_un-spam_rubin at yahoo.com> wrote in message
news:b71t5c$d3f$1 at news.Stanford.EDU...
> How do I free the temporary clob when I'm done with it in DCOracle2? I get
> an error when I try to close the temporary clob:
> >>> clob = connection.LobLocator('SQLT_CLOB')
> >>> clob.write('<f>foo bar</f>')
> >>> d='insert into foo values (XMLTYPE.createXML(:m))'
> >>> connection.execute(d, clob)
> >>> clob.close()
> Traceback (most recent call last):
> File "<stdin>", line 1, in ?
> dco2.DatabaseError: (22289, 'ORA-22289: cannot perform %s operation on an
> unopened file or LOB')
I know nothing about this, so it's just a stab in the dark: maybe you need
to commit the transaction before you close your clob, or close your clob
before you execute your SQL?
Steve Holden http://www.holdenweb.com/
Python Web Programming http://pydish.holdenweb.com/pwp/
Did you miss PyCon DC 2003? Would you come to PyCOn DC 2004?
More information about the Python-list