getcount() { xx1=`$ORACLE_HOME/bin/sqlplus -s apps/ostgapps1 2>/dev/null << EOF WHENEVER SQLERROR EXIT 1 SET HEADING OFF SET FEEDBACK OFF SET VERIFY OFF SET PAGESIZE 0 WHENEVER SQLERROR EXIT SQL.SQLCODE; select count(*) from XXPH_CMS_INVOICE_ALL; exit EOF` }
xx1=`getcount`