Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
![]() |
![]() |
Home -> Community -> Usenet -> c.d.o.tools -> Re: inserting into a long datatype column
I'm having the same problem.... any answers yet?
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
![]() |
![]() |