RE: ORacle db string over 4000 chars

2001-09-10 Thread The elephantwalker
: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-

RE: ORacle db string over 4000 chars

2001-09-10 Thread Komal Kandi (Contractor)
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

RE: ORacle db string over 4000 chars

2001-09-10 Thread Nusairat, Joseph F.
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

RE: ORacle db string over 4000 chars

2001-09-09 Thread Gregory Scott
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

RE: ORacle db string over 4000 chars

2001-09-08 Thread Khaled Alakhras
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

Re: ORacle db string over 4000 chars

2001-09-08 Thread Daniel Lopez
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

Re: ORacle db string over 4000 chars

2001-09-07 Thread Stephen Davidson
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

RE: ORacle db string over 4000 chars

2001-09-07 Thread The elephantwalker
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

RE: ORacle db string over 4000 chars

2001-09-07 Thread Nusairat, Joseph F.
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

RE: ORacle db string over 4000 chars

2001-09-07 Thread SAURUGGER,PETER (A-PaloAlto,ex2)
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