$SQLPLUS -S $sql_user_name/$sql_user_pwd@$sql_service
--set head off;
--set echo off;
--set serveroutput on;
begin
for name in `cat $INPUT_FILE`
do
    
    insert into numbers(select number from numberdb
    where name =&1);
    $name
    END LOOP;
    EOF
done

  
      for number in `cat $INPUT_FILE`
         do
            $SQLPLUS -S $sql_user_name/$sql_user_pwd@$sql_service <<EOF 1>>$LOG_FILE 2>>$LOG_FILE   
          set head off;   
          set echo off;
           set serveroutput on;

for number in `cat $INPUT_FILE`
do
   $SQLPLUS -S $sql_user_name/$sql_user_pwd@$sql_service <<EOF 1>>$LOG_FILE 2>>$LOG_FILE
    set head off;
    set echo off;
    set serveroutput on;
    exec number_names(&1);
    $number
    EOF

$SQLPLUS -S $sql_user_name/$sql_user_pwd@$sql_service
exec emp_history();
commit;
.
.
.
vi /suresh/emp_his.txt

printf("[%s]",str);

     while(fread(dest,1,11,fp)!= NULL)
        {
        dest[10] = 0;
        strncpy(acc_id.arr,dest,10);
        acc_id.len = strlen(acc_id.arr);

 while(fread(dest,1,11,fp)!= NULL)
        {
        dest[10] = 0;
        strncpy(pincode,dest,10);
        length = strlen(pincode);
        .
        .
        .

while(fgets(pincodefromfile,6,fp)!= NULL)
{
  EXEC SQL 
  Select * from