ON_ERROR Option [Interactive SQL]

Controls the action taken if an error is encountered while executing statements in Interactive SQL.

Allowed Values

String. See Description for allowed values.

Default

PROMPT

Description

Controls the action taken, if an error is encountered while executing statements:

  • 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.

When you are executing a .SQL file, the values STOP and EXIT are equivalent.