MySQL Forums
Forum List  »  Stored Procedures

Inserting errors into logs
Posted by: matthew Baynham
Date: April 20, 2020 07:10AM

I'm trying to write an error handler which will insert any errors into a log table so that I can log them and look at them later.

I know that "DECLARE EXIT handler for sqlexception" will catch the error.

I've read about "Show Errors;"

But how to I do an "insert into tblErrorLog (....) show errors", so that I put the errors into a log table?

Options: ReplyQuote


Subject
Views
Written By
Posted
Inserting errors into logs
295
April 20, 2020 07:10AM
130
April 20, 2020 11:29AM
107
April 22, 2020 06:58AM
121
April 22, 2020 02:45PM


Sorry, only registered users may post in this forum.

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.