Try putting an ';' at the end of your query.

Glenn.

--
Glenn Berry
Application Support Manager
Romeike Media Intelligence
Tel: +4420 8920 5360 Mob: +447789 811514
Fax: +44 20 8882 6716


> -----Original Message-----
> From: MCCCLAYTON
> [mailto:oracledba-ezmlmshield-x38767937.[Email address protected]
> Sent: 30 July 2004 14:30
> 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
>


***********************************************************************************
This email and any files transmitted with it are confidential and
intended solely for the use of the individual or entity to whom they
are addressed. If you have received this email in error please notify
the system manager of Romeike Media intelligence.
This footnote also confirms that this email message has been swept by
MIMEsweeper for the presence of computer viruses.
www.romeike.com
***********************************************************************************


Oracle LazyDBA home page