Exception handling and OUT/INOUT parameters

In some scenarios, stored programs do not return the modified values of OUT and INOUT parameters to the caller.

If a stored procedure exits due to an unhandled exception, the modified values of its OUT and INOUT parameters are not returned to the caller.

If the exception handler contains a RESIGNAL statement in a CONTINUE or EXIT handler, executing RESIGNAL will pop up the diagnostic area's stack, thereby issuing an exception signal (i.e., the information that existed before entering the handler). If the exception is an error, the OUT and INOUT parameters' values are not returned to the caller.