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
Phone: 214-696-6224 x208
