RE: CLOB

Suzanne,

I believe what you are going to need to do is create a temporary lob locator to hold the string and then insert the temporary lob instead of the string.

Ex.
  declare
    tmpCLOB CLOB;
    sData VarChar2(10000) := 'Some really long string that is more than 4k.';
  begin

• Loc Cache dbms_lob.createtemporary(tmpCLOB, TRUE, 10);
• Loc length offset string dbms_lob.write(tmpCLOB, Length(sData), 1, sData); insert into foo (foo_id, foo_notes) values (foo_seq.nextval, tmpCLOB); commit; end; /

The really cool thing about using the temporary lobs is that you can do updates to lobs without having to lock the row beforehand. This is a really good thing if you are working in java and already have the lob value in an object element.

Hope this helps,
Glen

-----Original Message-----
From: Johnson Poovathummoottil [mailto:joni_65_at_yahoo.com] Sent: Friday, November 03, 2000 8:31 AM
To: Multiple recipients of list ORACLE-L Subject: 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 - 10:09:27 CST