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 

##</code><code>##

$result=`sqlplus -s user/pass \@myfile`;
if($result=~/(?:SP2|ORA)/){
  print "SQL ERROR: $result\n";
}