whenever SQLERROR exit SQL.SQLCODE
set feeback off
set verify off
set lines 32
set pages 0
set linesize 500
set tab off *

your script

exit SQL.SQLCODE

*SQLPlus often formats white space in output using tab characters, not spaces... "set tab off" prevents this