Re: [Sqlrelay-discussion] Using SQLRelayDA to update CLOBs

[Firstworks/4access <dav...@fi...>]

On Mon, 2005-11-14 at 10:55 -0500, Seth Gottlieb wrote:
> Hello,
> 
> I am using SQLRelayDA to talk to Oracle 10g and one of my fields is a 
> CLOB.  When my update statement contains long strings, I get an error 
> from Oracle:
> 
> ORA-01704: string literal too long
> 
> Is there any simple way to do a prepared query with input binds through 
> the DA?  Or should I interface directly with the PySQLRClient?
> 
> Thanks,
> 
> Seth
> 

I'm not aware of any way to do input binds using the DA.  ZSQLRelayDA
uses the PySQLRDB.py module, which supports binds, but not Clob/Blob
binds :(  So, yeah, you'd need to use PySQLRClient to do Clob binds.

David Muse
dav...@fi...