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 to see if he or she wants to continue.
CONTINUE	Errors display 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 press Enter or click OK to continue.
NOTIFY_STOP	The error is reported, and the user is prompted to press Enter or click OK to stop executing statements.
NOTIFY_EXIT	The error is reported, and the user is prompted to press Enter or click OK 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.