Help for this page

Select Code to Download


  1. or download this
    whenever SQLERROR exit SQL.SQLCODE
    set feeback off
    ...
    exit SQL.SQLCODE
    
    *SQLPlus often formats white space in output using tab characters, not
    + spaces... "set tab off" prevents this
    
  2. or download this
    $result=`sqlplus -s user/pass \@myfile`;
    if($result=~/(?:SP2|ORA)/){
      print "SQL ERROR: $result\n";
    }