Do you have your ; at the end of the SQL statement?

Thanks,
Brenda :)



-----Original Message-----
From: MCCCLAYTON
[mailto:oracledba-ezmlmshield-x38767937.[Email address protected]
Sent: Friday, July 30, 2004 8:30 AM
To: LazyDBA Discussion
Subject: Am I missing something?




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