[Zope-DB] Clob's & DCOracle2

Bogdan M. Maryniuck b.maryniuk at forbis.lt
Mon Jul 19 11:49:44 EDT 2004


I got very latest CVS snapshot with crisw updates.
Here is my sourcechunk I would like to run (repeated):

-----------------------------------
d = DCOracle2.connect( ... )
c = d.cursor()

clob = d.LobLocator('SQLT_CLOB')
clob.write(msg)
try:
    out = c.procedure.dm_04.put(p_s = clob, p_r = '', p_commitMode =
None)
    print "SUCCESS"
except:
    out = None
    print "FAILURE"

out.open() # Do I need it? Probably no... :|
print type(out)
print dir(out)
print out.length()
print out.read()
-----------------------------------

And here is its output:
-----------------------------------
SUCCESS
<type 'LobLocator'>
['close', 'fileExists', 'getFileName', 'length', 'open', 'read', 'setFileName', 'trim', 'write']
54380
Traceback (most recent call last):
  File "clobprocedure.py", line 35, in ?
    print out.read()
dco2.DatabaseError: (1075348352,
'\\\x06\x04@\x90\x87\x18@(\xa2(\x08\xeag\x03@\\\x06\x04@\x90\x87\x18 at 0\x16\x13\x082\xec\x0b\x08|G\x0f\x08\xac\x17\x13\x08\x88\x97\x0f')
-----------------------------------

Wheee, DataaseError is not that usefull... :(
Any ideas?

-- 
Regards, Bogdan M. Maryniuk
Developer. Forbis UAB


More information about the Zope-DB mailing list