From: Derek Lee <derek@clti.com>
Subject: sqlplus exit code using personal oracle 7 for win95
Date: 1997/09/09
Message-ID: <34163EB1.2411F201@clti.com>#1/1
Reply-To: derek@clti.com
Newsgroups: comp.databases.oracle.server



Hello,
I'm trying to get the exit code from a sql*plus script runing
sqlplus from personal oracle 7 for win95. My script looks like
the following:

    whenever sqlerror exit 1;
    .
    .     <sql code>
    .
    exit 0;

In Unix, the exit code is correctly returned to the shell,
but using win95, I don't get the correct values.  To capture
the exit code in win95 I'm invoking sqlplus with the
GNU-win32 bash shell and also the java process commands
(Runtime.getRuntime().exec(command)).

In java, I always get an exit code of '6553128'. My same
code works fine with other commands.
Anybody, else out there getting reliable return codes from
sqlpus on win95?

Thanks,
Derek