Skip navigation links

MySQL Forums :: Stored Procedures :: Getting MySQL Error Trace from Procedure


Advanced Search

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 1084 Sachin Vyas 01/17/2013 10:56PM
Re: Getting MySQL Error Trace from Procedure 416 Rick James 01/21/2013 10:43AM


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.