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