Shell Programming and Scripting

#!/bin/sh
ORACLE_HOME=/var/opt/oracle/product/10g; export ORACLE_HOME
PATH=$PATH:$ORACLE_HOME/bin:/bin:/usr/bin; export PATH
today=`date "+%m-%d-%Y  %H:%M:%S"`; export today
SCRIPT_DIR=/arbor/integ_fx/scripts; export SCRIPT_DIR

LOG_FILE=error.log; export LOG_FILE

# Direct script output to log
exec > $LOG_FILE 2>&1


echo "LOGGING STARTS $today"
echo
echo

### Credentials for SQLPLUS


### Credentials for SQLPLUS

USER_ID=`cat .id_pass_file.txt | grep "^USER_ID" | cut -d "=" -f2`; export USER_ID
PWD=`cat .id_pass_file.txt | grep "^PWD" | cut -d "=" -f2`; export PWD
SID=`cat .id_pass_file.txt | grep "^SID" | cut -d "=" -f2`; export SID


### Connecting ORACLE

echo "SQLPLUS CONNECTION"

sqlplus -s $USER_ID@$SID/$PWD<<EOF>sql_output.txt
set feedback off
set heading off
select  1309  from adj where rownum < 2;

EOF


if [ $? -eq 0 ] 
then 
echo " SQLPLUS Connection Successful "
else
echo " SQLPLUS Connection Failed "
fi


for i in `cat sql_output.txt`
do
cd $SCRIPT_DIR
sh bip.sh 01 3 $i > bip.txt
sleep 360
echo "bip $i is running"
BILL_REF=`tail -2  bip.txt | head -1 | cut -d  " " -f  3`
cd ../xit_dev_CH/bin
ksh runXitInvoice_PROFORMA_integ  $BILL_REF 0 bp
done