How to free a temporary clob in DCOracle2?

Steve Holden 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>')
> 30
> >>> d='insert into foo values (XMLTYPE.createXML(:m))'
> >>> connection.execute(d, clob)
> 4
> >>> 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?

regards
--
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 mailing list