retcode=999
while [ $retcode -ne 0 ]
do
  sqlldr scott/tiger control=ulcase1.ctl log=ulcase1.log
  retcode=`echo $?`
  echo "$retcode"
  if [ $retcode -eq 0 ]
  then
    echo "SQL*Loader execution successful"
  else
    echo "There is error while running the sqlloader"
    echo "Errors found in ulcase1.log:"
    error_code=`grep ORA- ulcase1.log | sed 's/^/ /'`
    echo "$error_code"
  fi
done

handle_retcode() {
  if [ $1 -eq 0 ]
  then
    echo "SQL*Loader execution successful"
  else
    echo "There is error while running the sqlloader"
    echo "Errors found in $2:"
    error_code=`grep ORA- $2 | sed 's/^/ /'`
    echo "$error_code"
  fi  
}

retcode=999
while [ $retcode -ne 0 ]
do
  sqlldr scott/tiger control=ulcase1.ctl log=ulcase1.log
  retcode=$?
  echo "$retcode"
  handle_retcode $retcode ulcase1.log
done

for name in msg hist text act num 
do
  retcode=99999
  while [ $retcode -ne 0 ]
  do
    sqlldr scott/tiger control=${name}.ctl log=${name}.log
    retcode=$?
    echo "$retcode"
    handle_retcode $retcode ${name}.log
  done
done

handle_retcode() {
  # Parameters:
  # #1: sqlldr return code
  # #2: sqlldr log file
  rc=$1
  log=$2
  if [ $rc -eq 0 && `egrep -c '(ORA|SQL\*Loader|OCI|UL)-' $log` -eq 0 ]
  then
    echo "SQL*Loader execution successful"
  else
    echo "There were errors while running SQL*Loader (return code $rc, log $log)."
    egrep '(ORA|SQL\*Loader|OCI|UL)-' $log
  fi  
}

retcode=999