topic Re: Script Query in Operating System - HP-UX

Script Query

Hunki — Thu, 08 Feb 2007 09:04:53 GMT

I have this wrapper inside a script but it fails at this point with the following error :

line 39 :
/oracle/product/8.1.8/bin/sqlplus -s / <
syntax error at line 39 : `<<' unmatched

Re: Script Query

James R. Ferguson — Thu, 08 Feb 2007 09:13:21 GMT

Hi:

Make sure that your 'here' document body (the part begfore the 'EOF' is flush-left without leading spaces.

Regards!

...JRF...

Re: Script Query

Peter Godron — Thu, 08 Feb 2007 09:17:15 GMT

Hi,
have you code something like:
/oracle/product/8.1.8/bin/sqlplus -s / <select * from ....;
quit;
EOF

Watch out for leading spaces before the second EOF (there shouldn't be any).

Re: Script Query

spex — Thu, 08 Feb 2007 09:56:35 GMT

Hunki,

If you append - to <<, leading tabs are stripped from the here-document...

sqlplus -s / <<-EOF

PCS

Re: Script Query

Bill Hassell — Thu, 08 Feb 2007 12:02:04 GMT

Very important: EOF *must* be left-justified -- no leading spaces. The option <<- will allow leading tabs but NOT never leading spaces. It is common to indent 'here documents' for readability but the terminating string (EOF in your case) must start in column 1 to be recognized.

Re: Script Query

Hunki — Thu, 08 Feb 2007 12:44:11 GMT

I found the solution to this one ... thanks all for replying ,

(sqlplus -s / <blah blah ...

) > /dev/null