oracle - 如何在 pro *c/c++ 中限制 EXEC SQL 的范围 WHENEVER SQLERROR DO break

Question

在 oracle pro *c/c++ 中

EXEC SQL WHENEVER SQLERROR DO break;

这个声明实际上是做什么的？这将在所有以下 exec sql 语句中插入 break 语句？

如何限制do break的范围？

Answer 1

From the documentation :

DO BREAK

An actual "break" statement is placed in your program. Use this action in loops. When the WHENEVER condition is met, your program exits the loop it is inside.

因此，无论何时遇到错误，都会发出一个break，这在循环之外意义不大。如果您想在特定语句后重置行为，请发出 EXEC SQL WHENEVER SQLERROR CONTINUE; 以重置为默认错误处理行为:

CONTINUE

Your program continues to run with the next statement if possible. This is the default action, equivalent to not using the WHENEVER directive. You can use it to turn off condition checking.

实际上，您可以将一条语句夹在两个 WHENEVER 指令之间，使其仅适用于该语句。