Spool

[gucciaf]

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

[gucciaf]

Never mind. I figured it out.
Just changed the order of environment variables and it works.

set newpage 0
set space 0
set linesize 80
set pagesize 0
set echo off
set feedback off
set heading off

...then write SQL statements


F.G. : )