Re: CLOB

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.

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
>
Received on Fri Nov 03 2000 - 07:27:38 CST