[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