spooling from PL/SQL

From: Chris Eastwood <c.eastwood_at_gu.edu.au>
Date: 1998/05/19
Message-ID: <6jrf71$7v1$1@nkraken.itc.gu.edu.au>#1/1

HiYa

I am trying to get a clean spool file from PL/SQL, to mail the contents to users, but I can't stop it writing:

PL/SQL procedure successfully completed.

at the end of the file ... I have stopped it placing the substitution at the top of the file with using:

set ver off

in the PL/SQL before the declare, however I still can't get the trailer report to stop. Rather than awk this out of the file, and anyone help?

Thanks

See Ya
(when bandwidth gets better ;-)

Chris Eastwood

Photographer, Programmer               email    ua.ude.ug.cti_at_doowtsae.c
Motorcyclist and dingbat               WWW   http://chrise.itc.gu.edu.au

************************************************************************

Ohhh ... you work all day, slave over a hot stove all night yet you *still* have time for sadomasochism ... how do you do it?

A little man hurts me.

<ding>

    Oh Mister Mean ... Oh Mister Mean
    15 Minutes with him and you'll be blue and green     Studded belts and leather whips
    Bondage trousers on his hips
    Wack and punish as you dust with Mister Mean   Ohhhh he whips me around the house in minutes ... lets get cracking ... Received on Tue May 19 1998 - 00:00:00 CDT