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
wrong.........
ReplyDeleteplz provide what is correct
DeleteWe are a group of volunteers and opening a new scheme in our community.
ReplyDeleteYour 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.
Dani when u don't know why don't u keep quite
ReplyDeleteGet 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.
ReplyDeleteSite URL: https://sqloptimize.com
https://www.guest-articles.com/education/boost-your-career-with-new--real-vmware-2v0-6120-dumps-09-10-2020
ReplyDeleteRecognizing the importance of a healthy body and mind, we offer diverse massage and Russian spa in aerocity therapies to enhance your physical and mental well-being. Our packages come with numerous benefits visit to russian spa and massage: Achieve proper posture and alleviate joint pain,Call in spa aerocity 9319033293 leading to improved overall wellness through massage treatments. Experience detoxification of the body, massage and Russian spa services in Aerocity. Embracing a healthy and peaceful lifestyle by including in a full-body massage.
ReplyDelete