Whenever sqlerror

Transformation for this command is pending

Description

The WHENEVER SQLERROR command Performs the specified action (exits SQL*Plus by default) if a SQL command or PL/SQL block generates an error. (Oracle SQL Plus User's Guide and Reference)

Oracle Syntax

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

Snowflake does not support the use of this command and does not have any that might resemble its functionality. At the time of transformation, an EWI will be added.

1. Whenever sqlerror command

Oracle

Command

IN -> Oracle_01.sql

WHENEVER SQLERROR EXIT

SnowSQL (CLI Client)

Command

OUT -> Oracle_01.sql

!!!RESOLVE EWI!!! /*** SSC-EWI-0073 - PENDING FUNCTIONAL EQUIVALENCE REVIEW FOR 'WHENEVER ERROR STATEMENT' NODE ***/!!!
WHENEVER SQLERROR EXIT;

Known Issues

No Known Issues.

Related EWIs

1. SSC-EWI-0073: Pending Functional Equivalence Review.