ORA-06512: at line num
Cause: Backtrace message as the stack is unwound by unhandled exceptions.
Action: Fix the problem causing exception or write an exception handler for this condition. Or you may need to contact your application administrator or DBA.
Reference 1: http://docs.oracle.com/cd/A58617_01/server.804/a58312/newcha29.htm
Reference 2: http://docs.oracle.com/cd/B10500_01/server.920/a96525/intro.htm
ORA-06512 is simply a series of related messages issued at different levels of Oracle. in which the message directly preceding ORA-06512 will list the reason for the error.
The ORA-06512 error itself does not indicate the actual error. It normally indicates the line number at which the oracle PL/SQL code has caused an error. There will be another main error occurred in your process and that error happened in the line number as mentioned in ORA-06512 message description.
declare myname varchar2(5); begin myname := 'Nimish Garg'; end; / ERROR at line 1: ORA-06502: PL/SQL: numeric or value error: character string buffer too small ORA-06512: at line 4
Here the main error is "character string buffer too small" for the variable "myname" and it can be corrected by increasing the size of "myname"
declare myname varchar2(20); begin myname := 'Nimish Garg'; end; /
- ORA-00936 missing expression
- ORA-00911: invalid character
- ORA-01722: invalid number
- ORA-06550: line n, column n
- ORA-00904: invalid identifier
- ORA-06502: PL/SQL: numeric or value errorstring