That won't quite work as expected:

Code:

 > more gg.sql
whenever sqlerror exit sql.sqlcode;

select 1/0 from dual;

exit

 > sqlplus -s myid@mydb @gg.sql
Enter password:
select 1/0 from dual
        *
ERROR at line 1:
ORA-01476: divisor is equal to zero


 > echo $?
196
 >

So not quite.
has something to do with 1476 being modded down by 256 (or something - i'll let somebody more knowledgeable comment on that)

I've had most success by just grepping the output file for an ORA- error code (or SP2, etc.)

Code:

# error codes to look for (add/remove what you want to look for)
ERRCODES="(ORA-|EXP-|IMP-|KUP-|MOD-|PLS-|SP2-|SQL-|TNS-)"

sqlplus -s myid@mydb @gg.sql   2>&1 >> ${LOGFILE}
ERR=$?

ERRC=`egrep "${ERRCODES}" ${LOGFILE} | wc -l`

and then you have an error if either:
[ $ERR -ne 0 ] || [ $ERRC -ne 0 ]

Also, to the OP: Ken6503: you should be careful with this.

Your password will be visible to anyone on the same server, via "ps -ef" command.

If you're using an automated script, you really should consider externally defined ids, and then just use:

Code:

sqlplus -s  / @${DIR}/query.sql > outputfile