Re: ora 6502

From: Alex Filonov <afilonov_at_yahoo.com>
Date: 10 Dec 2002 07:26:32 -0800
Message-ID: <336da121.0212100726.652dc4bc@posting.google.com>

deepak_dasgupta_at_delhi.tcs.co.in (deepak) wrote in message news:<ed45575d.0212100332.792fa4ee_at_posting.google.com>...
> this throws an error:
> ORA-06502: PL/SQL: numeric or value error
> ORA-06512: at line 6
>
> any ideas.??
>
> declare
> x long;

You can't do any operations with LONG datatype (read documentation).

> y number;
> begin
> for i in 1..16001 loop
> x:=x||'AA';
> y:=length(x);
> end loop;
> end;
Received on Tue Dec 10 2002 - 09:26:32 CST