Suspected bug in DCOracle2 for LOB's
Daniel
dlUN-SPAMrubin at yahoo.com
Thu Jun 5 12:14:02 EDT 2003
I've installed the 2-1.3b DCOracle2 on windows and solaris. There's a
problem creating & inserting LOBs, and behavior is different for windows
and solaris (seg fault on solaris; error inserting the lob on windows).
This seems like a bug in DCOracle2?
**SOLARIS**
>>> db=DCOracle2.connect("me/pw at ora)
>>> c=db.cursor()
>>> clob=db.LobLocator("SQLT_CLOB")
>>> clob.write("<f>foo there</f>")
16
>>> d='insert into foo values(2, XMLTYPE.createXML(:m))'
>>> db.execute(d, clob)
4
>>> c.execute("commit")
0
>>> c.execute("select lobfield from foo where id=2")
1
>>> c.fetchone()
Segmentation fault
**WINDOWS**
>>> db=DCOracle2.connect("me/pw at ora")
>>> c=db.cursor()
>>> clob=db.LobLocator("SQLT_CLOB")
>>> clob.write('<f>foo there</f>')
16
>>> d='insert into foo values(8, XMLTYPE.createXML(:m))'
>>> db.execute(d,clob)
Traceback (most recent call last):
File "<stdin>", line 1, in ?
File "DCOracle2\DCOracle2.py", line 1001, in execute
dco2.DatabaseError: (24805, 'ORA-24805: LOB type mismatch\nORA-06512: at
"SYS.XMLTYPE", line 0\nORA-
06512: at line 1')
--
To reply to me directly, please remove "UNSPAM" from my email address
More information about the Python-list
mailing list