exit

hi,

i'd like to retrieve the sql code from a sqlscript.

--fichier.sql
whenever sqlerror exit sql.sqlcode;
select * from doesnotexist;
--fichier.sql

when i launch sqlplus from the shell, this is what i get
$>sqlplus / @fichier.sql

blabla
ORA-942 : doesnotexist does not exist.... blabla

$>echo $?

174

so the return code of sqlplus is 174, while the sqlcode is 942. Why such a difference ?

I also noticed that it always differs from 768 for a ora error.

Any idea ?

Thx in advance

Antoine Received on Thu Jul 18 2002 - 11:26:24 CDT