RE: ORacle db string over 4000 chars

[The elephantwalker]

Title: ORacle db string over 4000 chars

the oracle thin driver can't handle any types larger than 4000 char, period. It doesn't matter whether you use long raw or whatever. If you have larger stuff, you will need to use clob or blob...these require reading and writing the character data or the byte[] data, taking care to use the empty_clob() and empty_blob() functions before your do your writing.

 

We will be posting an example of how to do this with a slsb on our site soon...

 

stay tuned...

 

regards,

 

the elephantwalker

www.elephantwalker.com

-----Original Message-----
From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]]On Behalf Of Nusairat, Joseph F.
Sent: Friday, September 07, 2001 12:10 PM
To: Orion-Interest
Subject: RE: ORacle db string over 4000 chars

I do realise oracle has 4000 varchar limits ... but i have seen other systems get around this by using LONG or LONG RAW data types instead .... however when i use those .... i still have it bug out at 4000 chars ....

 

Joseph Faisal Nusairat, Sr. Project Manager
WorldCom
tel: 614-723-4232
pager: 888-452-0399
textmsg: [EMAIL PROTECTED]

-----Original Message-----
From: Nusairat, Joseph F. [mailto:[EMAIL PROTECTED]]
Sent: Friday, September 07, 2001 11:39 AM
To: Orion-Interest
Subject: ORacle db string over 4000 chars

Does anyone know how to handle this oracle 8.x u can have a varchar set to 4k ... sooo to do more than that i tried using a long and a long raw .... and inserting it that way ... however whenver i go over 4000 chars it bombs .... any one come across this problem?

Joseph Faisal Nusairat, Sr. Project Manager
WorldCom
tel: 614-723-4232
pager: 888-452-0399
textmsg: [EMAIL PROTECTED]