Re: write a line to a report.

From: John Strange <jstrange_at_imtn.dsccc.com>
Date: 2000/05/18
Message-ID: <8g0pik$6h8$1@relay1.dsccc.com>#1/1

sql -------------------------------------- spool report_name_here select 'get an oracle book from a bookstore' from dual ; spool off

----------------pl/sql -------------------------------------

spool report_name_here

begin
DBMS_OUTPUT.PUT_LINE ('get an oracle book from a bookstore') ; end ;
spool off

elufker_at_boofura.swcp.com wrote:
: Hi All:

: I just need to write a line to a report that I am pulling together
: in a pl/sql script. I am using spool to capture the out to a file, but how
: can I write a line '*** THIS TABLE NEEDS TO BE TRUNCATED ****'.

: Thanks in advance for any help here.

: Eddie Lufker

--
While Alcatel may claim ownership of all my ideas (on or off the job),
Alcatel does not claim any responsibility for them. Warranty expired when u
opened this article and I will not be responsible for its contents or use.

Received on Thu May 18 2000 - 00:00:00 CDT