ORA-06512: at line num


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.

Example:
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"

Solution:
declare
myname varchar2(20);
begin
myname := 'Nimish Garg';
end;
/



Related Posts:
- 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

3 comments:

Post a Comment