[Zope-DB] Probable bug in DCOracle2; also issue tracker problem

[Daniel Rubin]

Hi,
The Issue Tracker isn't working--I cannot create a new
issue
(http://www.zope.org/Members/matt/dco2/Tracker)--when
I click "submit new issue" I get "Not Found".

I have a suspected bug with DCOracle2.  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@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@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')


Daniel

__________________________________
Do you Yahoo!?
Yahoo! Calendar - Free online calendar with sync to Outlook(TM).
http://calendar.yahoo.com