MySQL Forums
Forum List  »  InnoDB

Getting MySQL Procedure Error Trace
Posted by: Sachin Vyas
Date: January 17, 2013 01:14AM

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 Procedure Error Trace
2192
January 17, 2013 01:14AM


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.