Shell Programming and Scripting

Y=`sqlplus -s user/passwd<< EOF
exec test_Proc;
exit;
EOF`

if [ echo $Y | awk '/ERROR/ || /ORA-/' ] ; then
exit 1
fi

case $Y in
  (*ERROR*|*ORA-*) exit 1
esac

sqlplus -s user/passwd <<EOF
whenever sqlerror exit sql.sqlcode;
exec test_Proc;
exit;
EOF

RetCode=$?

#Check the return code from SQL Plus
if [ $RetCode != 0 ]
then
    echo "********************"
    echo "ERROR: The SQL Plus Command Failed. RetCode: $RetCode"
else
    echo "********************"
    echo "SQL Plus Successfully Ran. RetCode: $RetCode"
fi

if [ `egrep -c "ORA-|SP2-|PLS-|TNS-|UDI-" sql_log_file_name.log` > 0 ]
then
    echo "********************"
    echo "ERROR: The SQL Plus Command Failed."
    egrep "ORA-|SP2-|PLS-|TNS-|UDI-" sql_log_file_name.log
else
    echo "********************"
    echo "SQL Plus Successfully Ran."
fi