[Zope-DB] Oracle CLOB problem

Matthew T. Kromer matt@zope.com
Thu, 08 May 2003 15:05:13 -0400

Cliff Ford wrote:

> 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.
> Any comments would be appreciated.
> Cliff

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.

Matt Kromer
Zope Corporation  http://www.zope.com/