Using "whenever oserror" on Windows

From: Vsevolod Afanassiev <vafanassiev_at_yahoo.com>
Date: 2 Apr 2005 04:57:41 -0800
Message-ID: <1112446661.517897.234940@f14g2000cwb.googlegroups.com>

When writing SQL scripts for batch execution on UNIX I normally put "whenever sqlerror", "whenever oserror" at the top, for example

---

whenever sqlerror exit failure rollback
whenever oserror exit failure rollback

connect user/pass

<do something>

exit

---

and then check for return code from SQL*Plus.

For some reason it does not work on Windows - the "whenever oserror" bit leads to message
O/S Message: No such file or directory

For example:

---

whenever sqlerror exit failure rollback
whenever oserror exit failure rollback

connect / as sysdba
select * from dual;

exit

---

This is for Oracle 9.2.0.4.0 on Windows 2003.

File "glogin.sql" is where it should be, i.e. in ORACLE_HOME\sqlplus\admin.

It is not that I particularly need this "oserror" thing to work, but it would be nice to know what is wrong with it.

Thanks Received on Sat Apr 02 2005 - 06:57:41 CST