Oops, and you also don't need the "<<" for the LAST line, just the EOF

Do "select * from v\$database;" ... You need the escape character and the ";"

>>> "MCCCLAYTON" <oracledba-ezmlmshield-x38767937.[Email address protected] 07/30/04 09:30AM >>>


I have a SQL-PLUS command that's ran from HP UNIX, like so:

#!/bin/ksh
oracle_sid=test
$ORACLE_HOME/bin/sqlplus 'system/xxxx' <<EOF
select * from v$database
<<EOF

And my results are the I get connected in but it doesn't launch my query. I
get kicked back to the UNIX prompt with a statement of "Disconnected from
Oracle 8i." There are no errors.

What is it that I'm missing?



Mark




--------
website: http://www.LazyDBA.com
Please don't reply to RTFM questions
Oracle documentation is here: http://tahiti.oracle.com
To unsubscribe: see http://www.lazydba.com/unsubscribe.html
To subscribe: see http://www.lazydba.com
By using this list you agree to these terms:http://www.lazydba.com/legal.html



Oracle LazyDBA home page