Re: [Sqlrelay-discussion] Using SQLRelayDA to update CLOBs
Brought to you by:
mused
|
From: Firstworks/4access <dav...@fi...> - 2005-11-16 16:29:41
|
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... |