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
896
April 20, 2020 07:10AM
485
April 20, 2020 11:29AM
468
April 22, 2020 06:58AM
479
April 22, 2020 02:45PM
408
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.