Script refuses to run section in '<<EOF'

nukeu666 · 09-09-2008, 12:40 AM

A script does not run the part of my script in <<EOF/EOF

Code:

#!/bin/bash
/ora01/oracle/product/8.1.7/bin/sqlplus user@db/pwd<<EOF >>logfile
@/home/webops/null_process.sql
quit;
EOF

rest-of-script-runs-file

no logfile is made either
any ideas please?

Mr. C. · 09-09-2008, 01:53 AM

Here documents work fine :

Code:

$ cat foo.sh
#!/bin/bash

cat <<EOF >> output
line 1
line 2
line 3
EOF
[glacier:tmp] $ ./foo.sh
[glacier:tmp] $ cat output 
line 1
line 2
line 3

You haven't shown any evidence of a failure. Show how you actually invoke the script and any output.

nukeu666 · 09-09-2008, 07:26 AM

Quote:

Originally Posted by Mr. C.

Here documents work fine :

Code:

$ cat foo.sh
#!/bin/bash

cat <<EOF >> output
line 1
line 2
line 3
EOF
[glacier:tmp] $ ./foo.sh
[glacier:tmp] $ cat output 
line 1
line 2
line 3

You haven't shown any evidence of a failure. Show how you actually invoke the script and any output.

when i run it by ./run.sh there there is no output given by sqlplus, nor does it execute the query (the @.... line)

trickykid · 09-09-2008, 12:11 PM

I think what you're script is actually trying to insert or run with the sqlplus command combined with EOF is: "@/home/webops/null_process.sql" and not the contents of the sql file itself.

You should be able to just do something like this to run the sql commands within the /home/webops/null_process.sql file:

Code:

cat /home/webops/null_process.sql | /ora01/oracle/product/8.1.7/bin/sqlplus user@db/pwd

nukeu666 · 09-10-2008, 01:41 AM

thanks, that is a much cleaner way of donig it

but the original problem of cron not running the sqlplus line still persists.
running the script from prompt works fine
ill make a new thread for this problem since it seems to be a cron problem

trickykid · 09-10-2008, 10:29 AM

Quote:

Originally Posted by nukeu666

thanks, that is a much cleaner way of donig it

but the original problem of cron not running the sqlplus line still persists.
running the script from prompt works fine
ill make a new thread for this problem since it seems to be a cron problem

What does your crontab look like for running it? No reason to start a new thread, keep the same ongoing discussions together.

nukeu666 · 09-11-2008, 04:53 AM

ok..finally found that i had to export oracle environment variables to get sqlplus running

thanks