: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-
terest
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
page
Title: 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
Intermedia. Building Oracle XML applications is a book that gives an example on how to leverage XML and Intermedia.
>From: Khaled Alakhras <[EMAIL PROTECTED]>
>Reply-To: Orion-Interest <[EMAIL PROTECTED]>
>To: Orion-Interest <[EMAIL PROTECTED]>
>Subject: RE: ORacle db string
I remember seeing some thing like this with
Oracle8.1.6 that got fixed in 8.1.7.
Khaled
--- "Nusairat, Joseph F." <[EMAIL PROTECTED]>
wrote:
> 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
> ho
al 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
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
e-From:
[EMAIL PROTECTED]
[mailto:[EMAIL PROTECTED]]On Behalf Of Nusairat,
Joseph F.Sent: Friday, September 07, 2001 12:10 PMTo:
Orion-InterestSubject: RE: ORacle db string over 4000
chars
I do
realise oracle has 4000 varchar limits ... but i have seen other systems get
a
Title: 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. Projec
Title: ORacle db string over 4000 chars
use
clob instead of varchar
-Original Message-From: Nusairat, Joseph F.
[mailto:[EMAIL PROTECTED]]Sent: Friday, September 07, 2001
8:39 AMTo: Orion-InterestSubject: ORacle db string over
4000 chars
Does anyone know how to handle this
10 matches
Mail list logo