I'm launching SQL plus3.3 by an NT command script to execute an ABC.SQL file which will do some simple select statements on an Oracle 8.0 database.

ABC.SQL looks something like this....

SET FEEDBACK OFF
SET ECHO OFF
CLEAR COLUMNS
SET SPACE 0
SET PAGESIZE 0
SET LINESIZE 57
SET HEADING OFF

SPOOL c:\temp\ABCOUT.SPL
Select * from table ABC
SPOOL OFF

EXIT
-----------------------------------------
My problem is that ABCOUT.SPL contains the select statement and the "SPOOL OFF" command.

I Just want ABCOUT.SPL to contain the results of the select statement.

Any ideas??? I'm out of them

Francesco Gucciardi