SQL Plus - WHENEVER OSERROR

> Procedural Languages > (SQL Plus|SqlCl) (Oracle Database Console)

1 - About

Performs the specified action (exits SQL*Plus by default) if an operating system error occurs (such as a file writing error).

In iSQL*Plus, performs the specified action (stops the current script by default) and returns focus to the Workspace if an operating system error occurs.

See also SQL Plus - WHENEVER SQLERROR

Advertising

3 - Syntax

WHENEVER OSERROR 
    { 
    EXIT [SUCCESS|FAILURE|n|variable|:BindVariable] [COMMIT|ROLLBACK] 
    | 
    CONTINUE [COMMIT|ROLLBACK|NONE]
    }

where:

  • you must choose the EXIT or CONTINUE statement
  • the block [SUCCESS|FAILURE|WARNING|n|variable|:BindVariable] define the exit code that can be:
  • the block [COMMIT|ROLLBACK] defines the transaction termination action to do.
lang/sqlplus/whenever_oserror.txt · Last modified: 2017/09/06 19:30 by gerardnico