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
796
April 20, 2020 07:10AM
402
April 20, 2020 11:29AM
411
April 22, 2020 06:58AM
405
April 22, 2020 02:45PM
385
April 23, 2020 12:38AM


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.