Re: CLOB

Friday 03 November 2000 16:30, ?????:
> Hi,
>
> All LOBs can store only 4000 chars in line. If you
> have to store more than that then you have to store
> it outside the table in separate tablespace.
>

That are you talking about ?!!!!
All LOB's can store up to 4 GigaBytes !
Satya can't you explain in details hw you writing into CLOB ?
may be the problem iz what you can't write more than 4000 byte in one time ..  

> Johnson
>
> --- "Weiss, Suzanne" <suzanne.weiss_at_intel.com> wrote:
> > I have the same question as Satya below. I don't
> > have the answer saved.
> > Can anybody answer this question again for me, it
> > would be greatly
> > appreciated?
> >
> > TIA.
> > -----Original Message-----
> > From: Satya Gandi [mailto:Satya.Gandi_at_East.Sun.COM]
> > Sent: Wednesday, August 23, 2000 12:07 PM
> > To: oracledba_at_lazydba.com
> > Subject: Re:CLOB
> >
> >
> > Tring to insert more than 4000 characters into the
> > field of CLOB type and
> > got
> > the error
> >
> > ORA-01704 string literal too long
> >
> > Cause: The string literal is longer than 4000
> > characters.
> >
> > Action: Use a string literal of at most 4000
> > characters. Longer
> > values
> > may
> > only be entered using bind variables.
> > ^^^^
> >
> >
> > can anyone help me to overcome this error.
> >
> > Thanks & Regards
> > Satya
> >
> >
> >
> >
> > --------
> > If you're bored, then visit the list's website:
> > http://www.lazydba.com
> > (updated daily)
> > to unsubscribe, send a blank email to
> > oracledba-unsubscribe_at_quickdoc.co.uk
> > to subscribe send a blank email to
> > oracledba-subscribe_at_quickdoc.co.uk
> >
> >
> >
> > --------
> > Think you know someone who can answer the above
> > question? Forward it to them!
> > to unsubscribe, send a blank email to
> > oracledba-unsubscribe_at_LAZYDBA.com
> > to subscribe send a blank email to
> > oracledba-subscribe_at_LAZYDBA.com
>
> __________________________________________________
> Do You Yahoo!?
>
> >From homework help to love advice, Yahoo! Experts has your answer.
>
> http://experts.yahoo.com/

-- 
Regards, Olefirenko Alexander