Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.server -> sqlplus exit code using personal oracle 7 for win95

sqlplus exit code using personal oracle 7 for win95

From: Derek Lee <derek_at_clti.com>
Date: 1997/09/09
Message-ID: <34163EB1.2411F201@clti.com>#1/1

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 Received on Tue Sep 09 1997 - 00:00:00 CDT

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US