Getting MySQL Error Trace from Procedure
Posted by: Sachin Vyas
Date: January 17, 2013 10:56PM
I am currently using :
Server version: 5.5.17 MySQL Community Server (GPL)
I need to get error trace from stored procedures/functions, which give me atleast the procedure name that caused the error.
(more info like line no. etc as it is displayed in Oracle would be great
ORA-06502: PL/SQL: numeric or value error: character to number conversion error
ORA-06512: at "HR.TEST", line 6
ORA-06512: at line 2
ERROR 1146 (42S02): Table 'test_db.a' doesn't exist
As we can see, MySQL does not returns the line no. & procedure name that caused the exception/error.
It becomes difficult to debug where the error actually occured in case of nested procedure calls.
Is there a way in MySQL to get the error trace as displayed in Oracle above?
Sorry, you can't reply to this topic. It has been closed.
Content reproduced on this site is the property of the respective copyright holders. It is not reviewed in advance by Oracle and does not necessarily represent the opinion of Oracle or any other party.