Shell Programming and Scripting

for j in $(cat $dirname/ctl_file.log)
 do
 
   if [ -n $j ]
   then
  Y=${#fileclob_ctl_file}
  if [ $Y = 0 ]
  then
    fileclob_ctl_file=$j
 
  else
    fileclob_ctl_file="${fileclob_ctl_file},${j}"
 
  fi
   fi
 done

`sqlplus  ${sysuser}/${syspwd} << dataload_ctl_file
     set pagesize 0 feedback off verify on heading off echo off serveroutput on
        whenever sqlerror exit sql.sqlcode;
        whenever oserror exit failure;
      set longchunksize 200000 long 200000 pages 0 
                        execute sp_update_log('$fileclob_ctl_file', $create_seq);      
 
        COMMIT;
       exit;