Re: ORA-06502 PL/SQL Error

I can think of a couple of reasons;

1. Assign a non-numeric value to a number

DECLARE
    my_number NUMBER;
BEGIN
    my_number := 'ABC';
END; More likely is this example where the value is too large for the field.

DECLARE
    my_number NUMBER(3);
BEGIN
    my_number := 1111; -- 4 into 3 won't go! END; Stewart Burnett

Please remove 'nospam' from address when replying direct.

Marcello Fantini wrote in message <363994DD.394A_at_tsr.ch>...
>Does anyone know about this error and how it may happen ?
>Full text is:
>SQL-Error
>Error-Numner -6502
>Error-Text ORA-6502: PL/SQL: numeric or value error
>
Received on Fri Oct 30 1998 - 05:54:17 CST