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