Using Whenever OSERROR in SQL*Plus does not Disconnect as in Previous Versions
(Doc ID 456787.1)
Last updated on FEBRUARY 26, 2019
Applies to:SQL*Plus - Version 10.2.0.3 and later
Information in this document applies to any platform.
*** Checked for relevance on 26-Feb-2019 ****
SQL*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> !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> !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