here is sample link for Clob datatype
<http://technet.oracle.com/doc/java.815/a64685/samapp2.htm>
http://technet.oracle.com/doc/java.815/a64685/samapp2.htm
-----Original Message-----
From: Nusairat, Joseph F. [mailto:[EMAIL PROTECTED]]
Sent: Monday, September 10, 2001 8:49 AM
To: Orion-Interest
Subject: RE: ORacle db string over 4000 chars
Ok .... so i use a Clob ... then i save it with a setAsciiStream and get
it with a getClob?>>>
Does anyone have a quick example i could seee
thanks
Joseph Faisal Nusairat, Sr. Project Manager
WorldCom
tel: 614-723-4232
pager: 888-452-0399
textmsg: [EMAIL PROTECTED]
-----Original Message-----
From: Stephen Davidson [ mailto:[EMAIL PROTECTED]
<mailto:[EMAIL PROTECTED]> ]
Sent: Friday, September 07, 2001 5:14 PM
To: Orion-Interest
Subject: Re: ORacle db string over 4000 chars
Hi Joseph.
Yes, we have seen this.
We found two solutions/workarounds.
Solution 1:
Set the field type to long varchar, and used the oracle 816classes12.zip
file for the drivers (the later ones have a bug in them that won't
handle strings over 2K).
Solution 2:
Set the field type to BLOB or CLOB (Binary/Character Large Object), and
read/write the data as a Stream.
Which solution to use (or whether they will apply for you) depends on
your needs. For the application I am working on, we are using both
solutions.
-Steve
> "Nusairat, Joseph F." wrote:
>
> 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]
--
Stephen Davidson
Java Consultant
Delphi Consultants, LLC
http://www.delphis.com <http://www.delphis.com>
Phone: 214-696-6224 x208