15.6.7.8 Condition Handling and OUT or INOUT Parameters (original) (raw)

15.6.7.8 Condition Handling and OUT or INOUT Parameters

If a stored procedure exits with an unhandled exception, modified values of OUT andINOUT parameters are not propagated back to the caller.

If an exception is handled by a CONTINUE orEXIT handler that contains aRESIGNAL statement, execution ofRESIGNAL pops the Diagnostics Area stack, thus signalling the exception (that is, the information that existed before entry into the handler). If the exception is an error, the values of OUT andINOUT parameters are not propagated back to the caller.