sql script question

From: <dennishancy_at_eaton.com>
Date: Wed, 23 Sep 1998 18:00:24 GMT
Message-ID: <6ubcvo$u8v$1_at_nnrp1.dejanews.com>

I have a SQL script that looks like this. Its purpose is to list the contents of a program to a file.

---

set head off

accept pgm char prompt 'Enter the program name: '; accept filename char prompt 'Enter the file where the output should be stored:';

set term off

spool '&filename'

select text
  from all_source
 where name like (upper('&pgm')) || '%'
   and type = 'PACKAGE BODY'

spool off
set term on
set head on

---

Why is it that when I run this, 1) the output is STILL spooled the screen, and 2) no output is spooled to the file I specified?

Thanks in advance..

Dennis Hancy
Eaton Corporation
Cleveland, OH

-----== Posted via Deja News, The Leader in Internet Discussion ==----- http://www.dejanews.com/rg_mkgrp.xp Create Your Own Free Member Forum Received on Wed Sep 23 1998 - 20:00:24 CEST