13.6.7.8 Condition Handling and OUT or INOUT Parameters条件处理和输出或输入参数

If a stored procedure exits with an unhandled exception, modified values of OUT and INOUT parameters are not propogated back to the caller.如果存储过程退出时出现未经处理的异常,则OUTINOUT参数的修改值不会传播回调用方。

If an exception is handled by a CONTINUE or EXIT handler that contains a RESIGNAL statement, execution of RESIGNAL pops the Diagnostics Area stack, thus signalling the exception (that is, the information that existed before entry into the handler). 如果异常由包含RESIGNAL语句的CONTINUEEXIT处理程序处理,RESIGNAL的执行会弹出诊断区域堆栈,从而发出异常信号(即进入处理程序之前存在的信息)。If the exception is an error, the values of OUT and INOUT parameters are not propogated back to the caller.如果异常是错误,则OUTINOUT参数的值不会传播回调用方。