Unexpected end of file


 
Thread Tools Search this Thread
Top Forums Shell Programming and Scripting Unexpected end of file
# 1  
Old 10-20-2010
Unexpected end of file

Hi,

On adding below code to my script shows the error on executing else script works fine.

Code:
sqlplus $user_name/$password <<EOL
truncate table order;
commit;
truncate table order_hist; 
commit;           
insert into order(ID,TRAN,CUST_NAME,OPT_VAL) select * from order_bkp;
insert into order_hist(ID,TRAN,CUST_NAME,OPT_VAL) select * from order_hist_bkp;
drop table order_bkp;
drop table order_hist_bkp;
EOL

Error:
syntax error: unexpected end of file

Where mistake is done in the above ?

With Regards
# 2  
Old 10-20-2010
Are you sure there isn't an error (for example an unterminated quote), probably in the lines just before this section?

Last edited by Scrutinizer; 10-20-2010 at 07:54 AM..
# 3  
Old 10-20-2010
Hi,

There is no unterminated quote before this.

is this can be due to use of multiple if ...else statement in the code ?

With Regards
# 4  
Old 10-20-2010
First impression, you are not exiting sqlplus.
Last line before "EOL" should be:
Quote:
quit;
If this isn't the fix, please post the whole script (blanking any passwords etc.).
Please state what Operating System you have and what Shell you use.
Please post the complete error message (case-significant with all punctuation). There is no Shell or Oracle which will just give an error message "syntax error: unexpected end of file".
# 5  
Old 10-20-2010
does your final "EOL" appear exactly as listed i.e. with no spaces/tabs before it on the line ? (This would cause it to break...)
This User Gave Thanks to Tytalus For This Post:
# 6  
Old 10-20-2010
Hi,

Its was problem of spaces, removed and it worked.

Thanks

With Regards
Login or Register to Ask a Question

Previous Thread | Next Thread

10 More Discussions You Might Find Interesting

1. Shell Programming and Scripting

unexpected end of file

I dont know where I missed the double quotes .:wall:pls review this code and help me out . m1: line 26: unexpected EOF while looking for matching `"' m1: line 34: syntax error: unexpected end of file echo "script is created by prabhu Kumar "; echo "changing the directory to wes... (2 Replies)
Discussion started by: ptappeta
2 Replies

2. Shell Programming and Scripting

Unexpected End Of File Error

Hi guys, I am new to BASH scripting and I was wondering if anyone could have a look at this code and explain to me why I am getting an Unexpected End of File Error ? If you can that would be great / much appreciated! THANKS! #!/bin/bash USER="" PASS="" if ; then echo "You need to set... (1 Reply)
Discussion started by: spooke
1 Replies

3. Shell Programming and Scripting

Unexpected end of file error

Hi , I am new to Unix and this is my first shell script . I am facing "unexpected end of file error" while executing my code . tried removing blank spaces Unable to trace out the error . PLease help !!! #!/bin/sh echo hello if ] echo hi then var=`cat liq_table_nm.txt` ... (6 Replies)
Discussion started by: sen180185
6 Replies

4. Shell Programming and Scripting

Unexpected end of file, why?

I am getting a "line 47: syntax error: unexpected end of file", why? According to my estimate, line 47 is 2 lines after the last line of code here. Also, the $1 variable represents the current user logging in, and the script runs with root privileges (This is a Mac OS login hook script using... (5 Replies)
Discussion started by: glev2005
5 Replies

5. Shell Programming and Scripting

unexpected end of file error

hi, i am trying to connect to sqlplus in an 'if block' from the script. it is giving unexpected end of file error. and it works fine if it is out of 'if block'. if anybody have idea on this, can you please help me to solve the error ? piece of code is given below. if then... (11 Replies)
Discussion started by: vinayakatj56
11 Replies

6. Shell Programming and Scripting

'end of file' unexpected

HELP PLEASE!! I am running this script, and i keep getting the error 'end of file' unexpected. I know that usually means parenthesis or whatever is out of place but i cant find anything!! I am new to scripting and i put some "print" staements in and it is not getting past the first IF statment... (7 Replies)
Discussion started by: weatherman0516
7 Replies

7. Shell Programming and Scripting

'end of file' unexpected

HI, I was converting a .bat file to .sh file for unix Code snippet #!/usr/bin/sh set -x if then goto RegularBuild; CURDIR="$1"; cd "$CURDIR"; :RegularBuild echo "Checking for existing fip_help.properties in def/properties directory..." if then rm -f fip_help.properties; ... (1 Reply)
Discussion started by: srisreeku
1 Replies

8. Shell Programming and Scripting

end of file unexpected

hi i have error like this' syntax error end of file unexecpeted.and give me the example of cut command as soon as possible: (1 Reply)
Discussion started by: naveeng.81
1 Replies

9. Shell Programming and Scripting

unexpected end of file

This is the script path=/oracle/ora10gdb/sample archive=/oracle/ora10gdb/archive cd $path for i in `ls`;do mv $i $archive Done Please tell me why it is givind this error (2 Replies)
Discussion started by: dineshr85
2 Replies

10. Shell Programming and Scripting

'end of file' unexpected

what do u mean by " 'end of file' unexpected "? i am running a script called "s1" which internally calls "s2" now s1 starts running & at a point (where it is suppose to call "s2") i get a message 'end of file' unexpected.... & my script(s) are not working.. any ideas on this? regards... (4 Replies)
Discussion started by: abhijeetkul
4 Replies
Login or Register to Ask a Question