Hi all,

I have the following piece of code in one of my shell script.


........
if [ $choice -eq 1 ]
then
no_of_constraints=`sqlplus -s $OracleId 2>/dev/null <<EOF
set heading off;
set verify off;
set feedback off;
select count(*) from user_constraints where table_name='$table_name';
exit;
EOF`
......

I have ended the if loop properly after this.

Now when I am running this shell script I am getting the following error:
here document `EOF' unclosed

It will be really useful if anyone can suggest probable cause for this error.


Thanks and Regards
Prasun

i noticed the ` after EOF, hope this is a typo...

No it's not a typo , basically ` is also there just before sqlplus(no_of_constraints=`sqlplus)

So ` after EOF ends the ORACLE session.

Thanks

missed that ;-)

Yeah it's ok .............but it will be really nice if anyone can provide me the real cause of the problem

Thanks
Prasun

The real cause of the problem is, as teebones has pointed out, the ` at the end of EOF. The ` should be at the end of the command - the hereis document ends with a line containing EXACTLY AND ONLY the content of the initial tag. Add that ` and it breaks, as you've found. That line should look like
I find it easier to echo the command in, personally.

I have just come across this error in a shell file.
#!/bin/ksh
sqlplus apps/apps << EOF
select * from dual;
exit;
EOF

Eventually I found out that the second EOF had a space after the EOF which when removed fixed the problem

Any lines precede << VAR need to be terminated by VAR on a line by itself. So the backtick (`) was the problem.