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

Written By
Inserting errors into logs
April 20, 2020 07:10AM
April 20, 2020 11:29AM
April 22, 2020 06:58AM
April 22, 2020 02:45PM
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.