MySQL Forums
Forum List  »  InnoDB

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

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

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

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?

Sachin Vyas.

Options: ReplyQuote

Written By
Getting MySQL Procedure Error Trace
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.