Re: SqlPlus report keeps outputting the SQL statement

From: news.kolumbus.fi <Jaakko.Terhonen_at_kolumbus.fi>
Date: Thu, 23 Aug 2001 20:19:49 +0200
Message-ID: <9m3doe$mrk$1_at_news.kolumbus.fi>


> well he's not wrong ...
>
> however:
> set echo offrt
> set pagesize 0
> set feedback off
> set termout off
> spool yourfile
> select ...
>
> Hth
> Thomas

Thank You, Thomas, but I already have those settings. Sorry Steve, I know You ment well...

There's something weird in this. I created a quick-and-dirty version of my report which reads EMP and DEPT tables and managed to get it to behave equally.

If anyone wishes to test this in his/hers own environment and see what is happening, here it is:

set pages 58
set newpage 0
set lines 80
set verify OFF
set term ON
set feedback off
set echo OFF
set space 1
set head OFF
SET wrap off
tti OFF

col departure      noprint new_value h_departure
col company       noprint new_value h_company
col   CurrDate       noprint new_value h_CurrDate
col   mencount       noprint new_value h_mencount  format 999
col   womencount     noprint new_value h_womencount format 999
col   allcount       noprint new_value h_allcount   format 999

col passname       for a38 hea 'NAME'

SELECT to_char(sysdate,'dd.mm.yyyy hh24:mi') CurrDate,
        'ACME INC.' COMPANY,
        'DEP' departure,
        10 MENCOUNT,
        10 WOMENCOUNT,
        20 ALLCOUNT
  FROM
        DEPT
  WHERE
        ROWNUM = 1 ;

spool TESTREP.LST

tti left h_company -

        col     32 'TEST LIST' col 76 sql.pno format 999  -
        skip 'TESTREP.sql' col 32 h_CurrDate -
        skip 2 -
        left h_departure -
        skip 2 'Count:' h_MENCOUNT ' men,' h_womencount ' women, total of '
h_allcount skip 2
        ;


set head ON

SELECT ENAME PASSNAME FROM EMP; spool OFF
tti OFF

(Our Oracle version is 8.1.6) Received on Thu Aug 23 2001 - 20:19:49 CEST

Original text of this message