#!/bin/ksh  

. ${BINDIR:=./}/RIM_input.txt

export ORACLE_HOME=/usr/local/opt/oracle/product/10.2.0.5
export PATH=$ORACLE_HOME/bin:$PATH:

DBASE_HOST=$DB_HOST
DBASE_LOGIN=$DB_LOGIN
DBASE_PWD=$DB_PWD
procename=${1}
comit=${2}
sleep=${3}

#. /home/adba/.profile


EMAIL_ADBA=$EMAIL

DATE=$(date "+%Y-%m-%d.%H:%M:%S")

CMDNAME=${0}

SHORTCMDNAME=$(print ${CMDNAME} | awk -F/ '{print $NF}')

HOSTNAME=`hostname`

#################################################################
#################################################################

LOGFILE=${SHORTCMDNAME}_${procename}_${DATE}.log
exec 1>${LOGFILE} 2>&1
print "\n${SHORTCMDNAME}  STARTING => $(date "+%A %B %d, %Y %H:%M:%S")\n"

#################################################################
#################################################################

function Send_Error {

  cat ${LOGFILE}|mailx -s "ERROR: ${procename}" ${EMAIL_ADBA}
  print "\nERROR: ${procename}"
  print "       Sent to ${EMAIL_ADBA} "
  print "\n${SHORTCMDNAME}  ABORTING => $(date "+%A %B %d, %Y %H:%M:%S")\n"
  exit 1
}

function Send_Msg {

#(cat $LOGFILE; uuencode ./${LOGFILE} ./${LOGFILE}) | mailx -s "Message: ${procename}" ${EMAIL_ADBA}

cat ${LOGFILE}|mailx -s "Message: ${procename}" ${EMAIL_ADBA}

#uuencode ${LOGFILE} ${LOGFILE} | mailx -s "Message: ${procename}" ${EMAIL_ADBA}
  print "\nMessage: ${procename}"
  print "         Sent to ${EMAIL_ADBA} "
  print "\n${SHORTCMDNAME}  ENDING => $(date "+%A %B %d, %Y %H:%M:%S")\n"
  exit 0
}


function Delete_Records {

print "\nMessage: Starting ${0} at $(date "+%A %B %d, %Y        %H:%M:%S")" 

sqlplus -S $DBASE_LOGIN/$DBASE_PWD@$DBASE_HOST  << EOF > ${LOGFILE}
set echo on
set time on
set timing on
set serveroutput on size 1000000
exec ${procename}(${comit}, ${sleep});
EOF

 cat ${LOGFILE} 

 if [[ ! -s ${LOGFILE}  ]]; then
   Send_Error "Error in ${LOGFILE}  File is empty or does not exist."
 elif [[ $(grep -c "ORA-" ${LOGFILE}) -ne 0 ]]; then
   Send_Error "Error in ${LOGFILE}.  Oracle error found."
 elif [[ $(grep -c "procedure successfully completed." ${LOGFILE}) -ne 1 ]]; then
   Send_Error "Error in ${LOGFILE}.  Unknow error found."
 fi

print "\nMessage: Ending ${LOGFILE} at $(date "+%A %B %d, %Y        %H:%M:%S")"  

}

#########################################################

if [[ ${procename} = "" || ${comit} = "" || ${sleep} = "" ]]; then
  print "Syntax Error >${SHORTCMDNAME} ${procename}  ${comit} ${sleep}"
   print "PROCNAME=${procename}"
   print "COMMITFREQUENCY=${comit}"
  print "SLEEP=${sleep}"
  Send_Error "Syntax Error in ${SHORTCMDNAME}"
fi

print "\nMessage: Starting ${SHORTCMDNAME} at $(date "+%A %B %d, %Y        %H:%M:%S")"
print "Message: Parameters PROCNAME COMMITFREQUENCY SLEEP " 
print "Message: Parameters ${procename} ${comit} ${sleep}" 
print "Message: Logs can be found in:\n`pwd`  "

Delete_Records ${procename} ${comit} ${sleep}

print "\n${SHORTCMDNAME}  Complete => $(date "+%A %B %d, %Y        %H:%M:%S")\n"
Send_Msg "${SHORTCMDNAME} is Complete"