Using Whenever Oserror in SQL*Plus does not Disconnect as in Previous Versions (Doc ID 456787.1)

Last updated on MAY 31, 2017

Applies to:

SQL*Plus - Version: 10.2.0.3.0
This problem can occur on any platform.

Symptoms

SQLl*Plus 10.2.0.3 is not exiting with Oserror failures.

In previous releases (9.2), this script finish the SQL*Plus session, exiting with oserror failure:

[SQL> whenever oserror exit failure 
SQL> !rm javier.txst 
rm: cannot lstat `javier.txst': No such file or directory 
O/S Message: No such file or directory 
Disconnected from Oracle9i Enterprise Edition Release 9.2 - Production 

In 10.2.03 SQL*Plus the same script does not exit:

SQL> whenever oserror exit failure  
SQL> !rm javier.txt.txt  
rm: cannot lstat `javier.txt.txt': No such file or directory  
SQL>  

The desired behavior is to be exited from Sql*Plus as this is an operating system error.  


Cause

Sign In with your My Oracle Support account

Don't have a My Oracle Support account? Click to get started

My Oracle Support provides customers with access to over a
Million Knowledge Articles and hundreds of Community platforms