The error
Oracle returns when a procedure runs into a numeric or value error. Looks like this:
ORA-06502: PL/SQL: numeric or value error
A 6502 is returned by PL/SQL when fetching a select-list item whose length is not determined at compile time (e.g. 'a'||'b' into a %rowtype variable).