ORA-06512

This is a Back trace error message.This normally displayed as ORA-06512: at line (linenumber).The below give example is a typical scenario.

Normally the first line of the error message (ORA-06502) indicates the error that occurred
The second line of the error message ( ORA-06512) indicates that the error occurred at line 5 of the PLSQL code.

Consider the following example

SQL> set serveroutput on;
SQL> declare
msg varchar2(10);
--num number;
begin
msg := 'String with more than 10 characters!';
--num := msg;
dbms_output.put_line(msg);
end;
/
declare
*ERROR at line 1:
ORA-06502: PL/SQL: numeric or value error: character string buffer too small
ORA-06512: at line 5

SQL>

Technorati Tags:
ORA-06512, oracle error, error codes