[Zope-DB] DCOracle2 not updating LOB field.

Yisheng Jin dilbert at gmail.com
Fri Nov 12 21:37:10 EST 2004


Hi,

I run into problem trying to update the Oracle lob field.

I tried to insert:

c.execute("insert into table values (1, 'name', EMPTY_CLOB())")
c.execute("select text from table where id = 1 for update")
a = c.fetchone()[0]
a.write("TESTSTRING")
c.execute('commit')

when i do c.execute("select text from table where id = 1")
b = c.fetchone()[0]
b.length()    I got 0
b.read()   I got none

b does show up as a loblocator object.   

What did I do wrong?  Thanks.


Jim


More information about the Zope-DB mailing list