Hello,

I am having some trouble with the SQLPlus tool over the command line.

Here is what I do:

on the command line I give the command:
sqlplus /nolog @c:\mycommands.sql

The mycommands.sql file contains:

CONNECT sys/syspass@mydatabase as sysdba
spool c:\output.txt
Select * from some_table
spool off
exit

However, the command line only shows the message connected and does not exit. The spool file also contains no information. I want it to execute the command and quit SQLPlus.

I hope someone can help me.

Thanks,
Pankaj

Works fine for me:

------------------------------------------------
C:\>type mycommands.sql
CONNECT scott/[email protected]
spool c:\output.txt
Select sysdate from dual;
spool off
exit

C:\>type output.txt
The system cannot find the file specified.

C:\>sqlplus /nolog @c:\mycommands.sql

SQL*Plus: Release 9.0.1.0.1 - Production on Sun Jun 27 15:07:09 2004

(c) Copyright 2001 Oracle Corporation. All rights reserved.

Connected.

SYSDATE
---------
27-JUN-04

Disconnected from Oracle8i Enterprise Edition Release 8.1.7.4.0 - Production
With the Partitioning option
JServer Release 8.1.7.4.0 - Production

C:\>
C:\>type output.txt

SYSDATE
---------
27-JUN-04


C:\>

--------------------------------------------------------

I am on W2K Pro.

AM