Oracle 使用返回变量从批处理文件调用SQL文件

tmpfile=/tmp/myjob.$$

print "
connect / as sysdba
set pages 0
set lines 200
set feedback off
set trimspool on
set serverout on
select '@COUNT '||count(*) x from all_tables
exit" | sqlplus -s /nolog 1>$tmpfile 2>&1

errs=`egrep '(SP2|ORA-)' $tmpfile`
if [ "$errs" ] ; then
  cat $tmpfile | mailx -s "ERROR: SOMETHING FAILED $bkptime" ops@business.com
  exit
fi
obj_count=`egrep '^@COUNT' $tmpfile | awk '{print $2}'`