[Zope-DB] Oracle CLOB problem

John Ziniti jziniti@speakeasy.org
Thu, 08 May 2003 14:53:36 -0500


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.

HTH,
JZ

Cliff Ford wrote:

> 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
>
>
> I should have added:
>
> 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.
>
> Cliff
>
>
> _______________________________________________
> Zope-DB mailing list
> Zope-DB@zope.org
> http://mail.zope.org/mailman/listinfo/zope-db
>
>