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 -> Re: sqlplus exit code using personal oracle 7 for win95

Re: sqlplus exit code using personal oracle 7 for win95

From: Derek Lee <derek_at_clti.com>
Date: 1997/09/11
Message-ID: <34184AB2.F858242D@clti.com>#1/1

Problem solved!
Instead of using 'sqlplus.exe' on Win95/NT I used 'plus33' and it behaves as expected. Exit codes work as coded.

-Derek

Derek Lee wrote:

> 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 Thu Sep 11 1997 - 00:00:00 CDT

Original text of this message

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