Re: Take of "Statement processed" in PL/SQL

From: Jason Salter <jason_at_seahorseNOSPAM.demon.co.uk>
Date: Wed, 29 Sep 1999 16:55:37 +0100
Message-ID: <9jXyN2J0sxosJF5q0VxneInaXBEo@4ax.com>

On Wed, 29 Sep 1999 15:30:58 GMT, screwbai_at_my-deja.com wrote:

>I am executing a PL/SQL statement and spooling it to a file.
>
>By using this option
>set echo off newpage 0 space 0 pagesize 0 feed off head off trimspool on
>serveroutput on
>
>I am able to get a nice file except for the first line where it says
>"Statement processed."
>
>Any ideas how I can get that off as well.

Apart from SET TERMOUT OFF the only thing I can think of, off the top of my head, is using the silent flag for sqlplus (-silent). Have you tried either of those?

Regards,
Jason. Received on Wed Sep 29 1999 - 10:55:37 CDT