[Zope-DB] Oracle CLOB problem - Resolved
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