Whenever oserror

Important Notice: Migration of Documentation Website

Please be advised that our documentation website is currently undergoing a migration to a new platform. To ensure you have access to the most up-to-date information, we kindly request that you visit our new documentation website located at:

Official Snowflake Snowconvert Documentation

For any immediate assistance or if you encounter any issues, please contact our support team at [email protected].

Thank you for your understanding.

Transformation for this command is pending

Description

The WHENEVER OSERROR command Performs the specified action (exits SQL*Plus by default) if an operating system error occurs. (Oracle SQL Plus User's Guide and Reference)

Oracle Syntax

WHENEVER OSERROR {EXIT [SUCCESS | FAILURE | 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 oserror command

Oracle

Command

IN -> Oracle_01.sql

WHENEVER OSERROR EXIT

SnowSQL (CLI Client)

Command

OUT -> Oracle_01.sql

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

Known Issues

No Known Issues.

Related EWIs

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