Re: update Blob on Oracle

[Bill Leng]

In fact, even 3.0.2 does not seem to directly support blob. For oracle, 
BLOB type in the xml is translated to BLOB in oracle. I have to change 
the generated SQL script from BLOB to LONG RAW. But, as said in the 
earlier email, I can only insert. Update failed at about 4000 bytes.

Lach, Thierry wrote:

That's kind of what I had been thinking when I asked the version - since
earlier versions of Torque (village, actually) didn't directly support
blobs.  But AFAIK that should not be an issue with 3.0.x.
-----Original Message-----
From: Gerard Airey [mailto:[EMAIL PROTECTED] 
Sent: Tuesday, July 08, 2003 11:29 AM
To: 'Turbine Torque Users List'
Subject: RE: update Blob on Oracle

Could the fact that the max varchar2 on Oracle is 4000 characters
indicate that it passing through a varchar2 stage somewhere?
-----Original Message-----
From: Bill Leng [mailto:[EMAIL PROTECTED]
Sent: 08 July 2003 15:39
To: Turbine Torque Users List
Subject: update Blob on Oracle
Hi,

I am using Torque on Oracle. My table has a column of the type LONG RAW.

I can insert with a byte array of about 2M. However, when I try to 
update it throught the Peer class's save method, I can only update with 
a byte array of about 4000 bytes. Has anybody encountered similar
problem?

thanks

--
Bill Leng
Metatomix, Inc.
Tel: (901)261-8911
Fax: (901)261-8901
---------------------------------------------------------------------
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]