Shell Programming and Scripting

#!bin/ksh
while IFS=, read var1 var2 
do

 sqlplus -s ${USERNAME}/${PASSWORD}@${ORACLE_SID} << EOF
    insert into ${TABLE}
        (
        appt_date
        )
  values
        (
        '${var1 }'
        );
    COMMIT;
    exit;
    EOF

done < "$file"

sh: Syntax error: '<<' is not matched.

sqlplus -s ${USERNAME}/${PASSWORD}@${ORACLE_SID} <<EOF

#!bin/ksh
while IFS=, read var1 var2 
do

 sqlplus -s ${USERNAME}/${PASSWORD}@${ORACLE_SID} << EOF
    insert into ${TABLE}
        (
        appt_date
        )
  values
        (
        '${var1 }'
        );
    COMMIT;
    exit;
EOF

done < "$file"

# will work:
some_process <<EOF
blah blah
EOF

# will not work:
some_process << EOF
blah blah
     EOF

     << [-]word
           The shell input is read up to a line that is the  same
           as word, or to an EOF. No parameter substitution, com-
           mand substitution, or file  name  generation  is  per-
           formed  on  word.  The  resulting  document,  called a
           here-document, becomes  the  standard  input.  If  any
           character  of  word  is  quoted,  no interpretation is
           placed upon the characters of the document. Otherwise,
           parameter  and command substitution occur, \NEWLINE is
           ignored, and \ must be used to quote the characters \,
           $,  `,  and  the  first  character  of  word.  If - is
           appended to <<, then all  leading  tabs  are  stripped
           from word and from the document.

 will work:
some_process <<EOF
blah blah
EOF

# will work as well:
some_process <<-EOF
blah blah
     EOF