I keep getting this error in my script:
"0403-057 Syntax error at line 6 : `<' is not matched."
I have gotten it before and the problem was EOF statement not being at the very beginning of a line. Not sure what is it this time. here is my script:
sqlplus -s /nolog <<EOF
set lines 4000
set trimspool on
set feedback off
set pages 0
SELECT fieldid, field1, field2 from my_view;
while read line
if [[ -n $line ]]
then eval $line
printf "[%-10s]\t[%-25s]\t[%-15s]\n" "$fieldid" "$field1" "$field2"