[Zope-DB] Oracle CLOB problem - Resolved

Cliff Ford Cliff.Ford@glg.ed.ac.uk
Fri, 9 May 2003 15:49:46 +0100

Thanks to Mat Kromer and John Ziniti for helping fix this problem.

The exchanges went like this:

> Can anybody advise? I have been using both Oracle and MySQL
> (it's a long story). All seemed in order until I needed to use Oracle
> CLOB fields. It turns out that I can't read or write BLOBs or
> CLOBs even with the example scripts on the zope.org How To
> page. I am using Oracle 9.2.0 (is  that the problem) with
> ZOracleDA 1.2 and Zope 2.5.1 (just about to switch to 2.6.1). The
> last set of correspondence I could find did mot  end up with a
> success/no success story.

> The scripts run without error but the list_blobs document returns
> 'None' for the CLOB values, even though some text has been
> entered by an alternative route.

>From Mat Kromer:

The binary build for 1.2 has a horrible 1-liner bug which makes the 
code think that all LOB objects are temporary.  Use the 1.3 or CVS 
builds and you should be OK.

>From John Ziniti:

Make sure that you have compiled your own dco2.so
and you should be able to write to the CLOBs.  I got
the same behavior as you, with seemingly successful
CLOB writes having no effect.  When I recompiled
DCOracle2 myself, it worked OK

So now I can read, write and update Oracle CLOBs.


Dr C.E.Ford, Senior Lecturer in Geology 
Grant Institute of Geology and Geophysics
Telephone (+44) 131 650 4838, Fax (+44) 131 650 5738