My Oracle Support Banner

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:
This problem can occur on any platform.


SQLl*Plus 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  

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


To view full details, sign in with your My Oracle Support account.

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

In this Document

My Oracle Support provides customers with access to over a million knowledge articles and a vibrant support community of peers and Oracle experts.