Re: max size of data in a LONG column

From: Richard Foote <richard.foote_at_bigpond.com>
Date: Tue, 10 Dec 2002 22:48:54 +1000
Message-ID: <JhkJ9.465$jM5.1402@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:54 CST