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



Oracle LazyDBA home page