I am using MYSQL 5.5 how to do error handling with a nested stored procedure. A practically significant part of the stored procedure, truncates the table, inserts it into select * from and inserts the key into the duplicate update.
If there is any problem with any nested stored procedure, I would like to catch this error or say that the error occurred in this particular stored procedure.
Right now, due to the nested stored procedure, I don't know where the procedure was stored, an exception has occurred.
source
share