Re: inserting into a long datatype column

Use a procedure.

1. Create a variable type LONG.
2. Assign the 4000+ character string to the variable.
3. INSERT the variable into the table.

jk

In article <8l065f$jru$1_at_nnrp1.deja.com>,   russellhitchcock_at_hotmail.com wrote:
> How do I insert something greater than 4K into a LONG
> column?
>
> Basically, I just
> want to verify that it will hold 2GB.
> Whenever, I do this I get the error
> ORA-01704: string literal too long.
> This error message indicates thats a
> string can not exceed 4K bytes. So
> I thought perhaps I needed to use a bind
> variable. But LONG can not be used for
> a bind variable.
>
> So how is this done... ie how do I insert
> something greater than 4K into a LONG
> column.
>
> I have set the command option LONG to 2000000000.
>
> I can't use CLOB's because I am using the UTF-8
> (variable width) character set.
>
> Thanks,
> Russ
>
> Sent via Deja.com http://www.deja.com/
> Before you buy.
>

Sent via Deja.com http://www.deja.com/
Before you buy. Received on Tue Jul 18 2000 - 00:00:00 CDT