Shell Programming and Scripting

Syntax error at line 11 : `for' is not matched.

#! /bin/ksh
sqlplus -s << !+!
user/password
update GR_SUB_SCRIPT_PC set act_del_ind='0';
commit;
exit;
!+!

cd /home/salunke/pvcsfiles/source_files

for i in *.sh
do
       ln_no=`grep -in description.*: $i | cut -f1 -d:`
       m_main_desc=""
       if [ $ln_no -ne "" ]
       then
       ln_no=`expr $ln_no + 1`
	echo "Line:$ln_no"
       head -$ln_no $i | tail -2 |sed -e 's/#//g' -e 's/*//g' -e 's/[Dd]escription.*://g'| tr -d "\n">desc.txt
       for line in $(cat desc.txt);
       do
       m_desc=`echo $line | sed -e 's/^$//'`
       m_main_desc="$m_main_desc $m_desc"
       done
       fi
       ln_no=`grep -in purpose.*: $i | cut -f1 -d:`
      if [ $ln_no -ne "" ]
       then
       ln_no=`expr $ln_no + 1`
	echo "Line:$ln_no"
	head -$ln_no $i | tail -2 |sed -e 's/#//g' -e 's/*//g' -e 's/[Pp]urpose.*://g'| tr -d "\n">desc.txt
	 for line in $(cat desc.txt);
	do
       m_desc=`echo $line | sed -e 's/^$//'`
      m_main_desc="$m_main_desc $m_desc"
     done
    fi
	  ln_no=`grep -in "Pgm Desc.*:" $i| cut -f1 -d:` 
	 if [ $ln_no -ne "" ]
	then
       ln_no=`expr $ln_no + 1`
       echo "Line:$ln_no"
       head -$ln_no $i | tail -2 |sed -e 's/#//g' -e 's/*//g' -e 's/[Pp]gm [Dd]esc.*://g'| tr -d "\n">desc.txt
	for line in $(cat desc.txt);
	do
       m_desc=`echo $line | sed -e 's/^$//'`
     m_main_desc="$m_main_desc $m_desc"
	  done
      fi


       rm log1.txt	
       grep -i "m_prog_name=" $i |sed -e 's/#.*//p' -e 's/echo.*//p' -e '/^$/ d'>log1.txt
       grep -i "pgm_name=" $i |sed -e 's/#.*//p' -e 's/echo.*//p' -e '/^$/ d'>>log1.txt
       grep -i "m_prog_nm=" $i |sed -e 's/#.*//p' -e 's/echo.*//p' -e '/^$/ d'>>log1.txt
       #awk '{split ($0,a,"="); print a[2]}' log1.txt |sed 's/[.a-zA-Z]* //g' |sed -e 's/"//g'|sed -e s/\'//g>proc.txt
       var_proc=`awk '{split ($0,a,"="); print a[2]}' log1.txt |sed 's/[.a-zA-Z]* //g' |sed -e 's/"//g'|sed -e s/\'//g` 
       #for line in $(cat proc.txt);
       #do
	       echo "Shell Name: $i and PC name: $var_proc Description:$m_main_desc"
	       ret_val=sqlplus -s << !+!
	       ganachar/abcd4161
	       set serveroutput off;
	       set echo off;
	       whenever sqlerror exit 1 rollback;
	       whenever oserror exit 1 rollback;
	       set serveroutput on
	       exec pg_gr_inventory.sp_insert_sub_script_pc('$i','$var_proc','$m_main_desc');
	       exit ;
	       !+!
       #done
done

sqlplus -s << !+!
user/passwd
delete from GR_SUB_SCRIPT_PC where act_del_ind='0';
commit;
exit;
!+!