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

CUR_DIR=$1
export CUR_DIR

LOG_FILE="$CUR_DIR/error.log"
export LOG_FILE

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

echo
echo
echo "LOGGING STARTS $today"
echo
echo
###Fetching the script directory from configuration file 
SCRIPT_DIR=`grep "^SCRIPT_DIR" "$CUR_DIR/.id_pass_file.txt" | cut -d "=" -f2`
export SCRIPT_DIR

### Credentials for SQLPLUS

USER_ID=`grep "^USER_ID" "$CUR_DIR/.id_pass_file.txt" | cut -d "=" -f2`
export USER_ID

PWD=`grep "^PWD" "$CUR_DIR/.id_pass_file.txt" | cut -d "=" -f2`
export PWD

SID=`grep "^SID" "$CUR_DIR/.id_pass_file.txt" | cut -d "=" -f2`
export SID


### Connecting ORACLE

echo "SQLPLUS CONNECTION"

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


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

##echo " The account numbers to be used in BIP are  "



if [ ! -s  "$CUR_DIR/sql_output.txt" ]
then
  echo "No account number for bad debt" 
  else
  while read LINE; do
    echo "bip $i is running"
    cd "$SCRIPT_DIR"
    sh bip.sh 01 0 "$LINE" >> "$CUR_DIR/bip_log_1.txt" ### Append to this one file, or a new file for each one?
    sleep 100
  done < "$CUR_DIR/sql_output.txt"
fi


###Removing temporary log files generated 

if [ -f  "$CUR_DIR/bip_log_1.txt" ]
then
 rm  "$CUR_DIR/bip_log_1.txt"
 echo "file bip__log_1.txt removed"
fi

if [ -f "$CUR_DIR/sql_output.txt" ]
then
 rm  "$CUR_DIR/sql_output.txt"
 echo "sql_output.txt removed"
fi

./it.sh: syntax error at line 26: `SCRIPT_DIR=$' unexpected

SQLPLUS CONNECTION
 SQLPLUS Connection Successful
bip  is running
libarbor_db/database_gen.c(4670): arb_db_err - Entry
   errtype           = 2
   exec_user_handler = 1
   errcode           = 936
   errtext           = Error in execution of OCI function unused:
retcode = -1 (OCI_ERROR)
ORA-00936: missing expression

   errsev            = 2
   errproc           = unknown
   line_no           = 0
   query             = 10053aba0