for i in {1..6}
do
  sqlplus user/password@db <<EOF



exec your_procedure
exit
EOF
  if [ $? -eq 0 ]; then exit 0; fi
  sleep 1800
done
(echo "From: <sender email>"
 echo "To: <to email>"
 echo "Subject: <your subject>"
 echo "Content-Type: text/ascii"
 echo "Content-Disposition: inline"
 echo "<your text>"
 ) | sendmail <to email>
exit 1

Procedure_checks()
{
      # Check for file existence
      if [ -f run_procedure.txt ]
       then
        print "\n run_procedure.txt found"

        # Obtain the number of error messages
        oract=`grep -c "ORA-" run_procedure.txt`
        spct=`grep -c "SP2-"  run_procedure.txt`
        errct=`grep -c -i "error" run_procedure.txt`

        # Report on the status of the log files
        if [ "$oract" = "0" ] && [ "$spct" = "0" ] && [ "$errct" = "0" ]
        then
         print "Appears to be good."
        else
         print "Appears to have a problem."
         ERR_FLAG=5
        fi

        # Regardless of errors print out the results
        print "      There are ($oract) Oracle errors"
        print "      There are ($spct) SQLPLUS errors"
        print "      There are ($errct) general errors"
      else
         print "**** Oracle Check Failed: Oracle log file not found ****"
         ERR_FLAG=6
      fi
     print "\n**** Oracle Check Complete ****"
     print "\n  "
}