How to free a temporary clob in DCOracle2?

Daniel dl_un-spam_rubin at yahoo.com
Wed Apr 9 15:43:39 EDT 2003


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')


Thanks,
Daniel






More information about the Python-list mailing list