Yes this was fixed in 8.1.7. The original poster should review the release notes. In addition, there has been a new data type that surpasses the long and the long raw it is called a Clob (charcter large binary object). If you are doing content management you might want to look into Oracle 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 over 4000 chars
>Date: Sat, 8 Sep 2001 22:22:29 -0700 (PDT)
>
>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 ....
> > 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]
> >
> >
>
>
>__________________________________________________
>Do You Yahoo!?
>Get email alerts & NEW webcam video instant messaging with Yahoo! Messenger
>http://im.yahoo.com
>
