Re: How to insert into clob's????

I changed my insert statement to

insert into lob_tab values (1,
'zeroonetwothreefourfivesixseveneigthninezeroonetwothreefourfivesixseveneigt hnine...(5000 char here)...zeroonetwothreefourfivesixseveneigthnine')

and got the following:

    SP2-0027: Input is too long (> 2499 characters) - line ignored

    Input truncated to 1 characters
    ERROR:
    Error while trying to retrieve text for error ORA-01756

From error messages:

ORA-01756 quoted string not properly terminated

Cause: A quoted string must be terminated with a single quote mark (').

Action: Insert the closing quote and retry the statement

The closing quote is NOT missing!

"mgumbs" <mgumbsNOmgSPAM_at_hotmail.com.invalid> wrote in message news:1aec1ec8.c2c9b5cc_at_usw-ex0104-026.remarq.com...
> It may or may not have anything to do with the clob.
>
> ORA-01704 string literal too long
>
> Cause: A quoted string specified as a constant was too long.
>
> Action: Quoted strings may not contain more than 2000
> characters.
>
> Is it possible for you to post your code?
>
> M
>
>
>
> -----------------------------------------------------------
>
> Got questions? Get answers over the phone at Keen.com.
> Up to 100 minutes free!
> http://www.keen.com
>
Received on Tue Jul 04 2000 - 00:00:00 CEST