Using Whenever Oserror in SQL*Plus does not Disconnect as in Previous Versions
Last updated on MAY 31, 2017
Applies to:SQL*Plus - Version: 10.2.0.3.0
This problem can occur on any platform.
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
The desired behavior is to be exited from Sql*Plus as this is an operating system error.
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