on_error option [Interactive SQL]

Controls what happens if an error is encountered while executing statements in Interactive SQL.

Allowed values

String (see below for allowed values)

Default

Prompt

Remarks

Controls what happens if an error is encountered while executing statements, as follows:

  • Stop   Interactive SQL stops executing statements.

  • Prompt   Interactive SQL prompts the user to see if they want to continue.

  • Continue   The error is ignored and Interactive SQL continues executing statements.

  • Exit   Interactive SQL shuts down.

  • 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 shut down Interactive SQL.

When you are executing a .sql file, the values Stop and Exit are equivalent. If you specify either of these values, Interactive SQL shuts down.

See also