my code is always stopping after ENDOFSQL; How to resolve this Problem and print the last echo?
#!/bin/bash
sqlplus db/pass << ENDOFSQL
@script.sql
exit;
ENDOFSQL;
echo -e "text"
-
code or something else ?Mingebag– Mingebag2013-03-05 14:33:07 +00:00Commented Mar 5, 2013 at 14:33
Add a comment
|
2 Answers
You must remove the semicolon ; at the end of ENDOFSQL;. Otherwise, your here document extends until the end of file and ENDOFSQL; and echo is part of the here document
#!/bin/bash
sqlplus db/pass << ENDOFSQL
@script.sql
exit;
ENDOFSQL
echo -e "text"
See Here Documents for details
The format of here-documents is:
<<[-]word here-document delimiterThis type of redirection instructs the shell to read input from the current source until a line containing only word (with no trailing blanks) is seen. All of the lines read up to that point are then used as the standard input for a command.
1 Comment
Dave
It is working without the semicolon ; at the end of ENDOFSQL !!! Thanks all for help : )
Call it like this:
#!/bin/bash
sqlplus db/pass @script.sql
echo -e "text"
Make sure you have the exit at the end of your .sql file.
