inserting UNIX variable values into oracle database

[dr3586]

Hi,

I am new at this so I apologize if all is not correct. In ksh unix script I am trying to read values from text delimited file into oracle db table. I know that the read from the text file is working so that is not problem.
...

IFS="^^"
exec < smt_output.txt

while read circuit vho ban junk device dvr; do

sqlplus -s usr/passwd <<-EOF
set termout off;
spool superbash_automation.lst;

INSERT INTO SUPERBASH(APPLICATION, BAN, STB_DEVICE_ID, CIRCUIT_ID, AP_ID, VHO, DVR_ENA)
VALUES ('SMT', $ban, $device, $circuit, null, $vho, $dvr);

done
spool off
exit
EOF


I do not know what the EOF means or does but think this is the problem. I have based what I have off examples. Can anyone please help it is very urgent. The error I get in running script it:

syntax error at line 14 : `<<' unmatched

[dr3586]

All,

Nevermind my question, I actually figured it out :) Thanks!