Using "whenever oserror" on Windows

I tried on another box - Windows 2000, Oracle 9.2.0.6.0, got the same
result...

I tried on another box - Windows 2000, Oracle 9.2.0.6.0, got the same
result...

I tried on another box - Windows 2000, Oracle 9.2.0.6.0, got the same
result...

I tried on another box - Windows 2000, Oracle 9.2.0.6.0, got the same
result...

I tried on another box - Windows 2000, Oracle 9.2.0.6.0, got the same
result...

I tried on another box - Windows 2000, Oracle 9.2.0.6.0, got the same
result...

I tried on another box - Windows 2000, Oracle 9.2.0.6.0, got the same
result...

"Vsevolod Afanassiev" wrote in message
news: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
>
>
>
> 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
>

Did you add something UNIX-specific to your glogin.sql file ?

Matthias

"Vsevolod Afanassiev" wrote in message
news: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
>
>
>
> 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
>

Did you add something UNIX-specific to your glogin.sql file ?

Matthias