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

6 comments:

  1. We are a group of volunteers and opening a new scheme in our community.
    Your web site () provided us with helpful
    info to work on. You have done an impressive job and our entire neighborhood
    might be grateful to you.

    ReplyDelete
  2. Dani when u don't know why don't u keep quite

    ReplyDelete
  3. Get Instant help from our expert for your Database issues or to Optimize your SQL Script. We will be charging on a hourly basis. You can initiate the chat with our expert for the best and fast solution.

    Site URL: https://sqloptimize.com

    ReplyDelete