Well, "blob" is _not_ the same as "long raw" in Oracle. Try leaving the database as a blob and work with it.
-----Original Message----- From: Bill Leng [mailto:[EMAIL PROTECTED] Sent: Tuesday, July 08, 2003 12:01 PM To: Turbine Torque Users List Subject: Re: update Blob on Oracle 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] --------------------------------------------------------------------- To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED]
