MySQL Forums
Forum List  »  Stored Procedures

Getting MySQL Error Trace from Procedure
Posted by: Sachin Vyas
Date: January 17, 2013 10:56PM

Hello,
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
ORACLE
=======

Error report:
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

MySQL
=====
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?


Regards,
Sachin Vyas.

Options: ReplyQuote


Subject
Views
Written By
Posted
Getting MySQL Error Trace from Procedure
3081
January 17, 2013 10:56PM


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.