Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.server -> Re: max size of data in a LONG column
Afternoon Richard (Morning?)
Max size 2Gb is for database LONG's. In PL/SQL it is only 32760.
Which explains the error message.
I did not find any evidence that length(long) shouldn't work, but the fact
is: it does ;-)
regards,
Peter
"Richard Foote" <richard.foote_at_bigpond.com> schreef in bericht
news:JhkJ9.465$jM5.1402_at_newsfeeds.bigpond.com...
> Hi Deepak,
>
> Max size is 2G.
>
> Length(long) is invalid.
>
> Don't know which version you're on but look at using a clob instead. Longs
> should be long gone.
>
> Cheers
>
> Richard
> "deepak" <deepak_dasgupta_at_delhi.tcs.co.in> wrote in message
> news:ed45575d.0212100317.1890bc20_at_posting.google.com...
> > this throws an error. any ideas.??
> >
> > declare
> > x long;
> > y number;
> > begin
> > for i in 1..16001 loop
> > x:=x||'AA';
> > y:=length(x);
> > end loop;
> > end;
>
>
Received on Tue Dec 10 2002 - 06:48:22 CST