Listing 13 demonstrates how a specific error can transfer control to the exit handler where a user-defined error message is returned depending on the value of the SQLCODE.

清单13展示了一个特定的错误如何将控制转移给退出处理程序，其中根据SQLCODE的值返回用户定义的错误消息。

youdao

It is a common practice to copy the values of SQLSTATE and SQLCODE into local variables in the first statement of the handler, as shown in Listing 11.

将SQLSTATE和SQLCODE的值复制到处理程序的第一个语句的本地变量中，这是一种常见的做法，如清单11所示。

youdao

Error handling: the new stored procedure now returns SQLCA with proper SQLCODE and SQLSTATE that is more inline with the error handling framework when using SQL.

错误处理：新的存储过程现在返回带有适当SQLCODE和SQLSTATE的SQLCA，在使用SQL时与错误处理框架更加内联。

youdao