ON_ERROR Option [Interactive SQL]
Controls the action taken if an error is encountered while executing statements in Interactive SQL.
Allowed Values
| Value | Description |
|---|---|
| STOP | Interactive SQL stops executing statements from the file and returns to the statement window for input. |
| PROMPT | Interactive SQL prompts the user whether to continue. |
| CONTINUE | Errors appear in the Messages pane, and Interactive SQL continues executing statements. |
| EXIT | Interactive SQL terminates. |
| NOTIFY_CONTINUE | The error is reported, and the user is prompted to continue. |
| NOTIFY_STOP | The error is reported, and the user is prompted to stop executing statements. |
| NOTIFY_EXIT | The error is reported, and the user is prompted to terminate Interactive SQL. |
Default
PROMPT
Remarks
Controls the action taken, if an error is encountered while executing statements. When you are executing a .SQL file, the values STOP and EXIT are equivalent.