Re: spooling from PL/SQL

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

In article <35614E5F.B006C402_at_exlibris.co.il>, Ariel Kirson <arielk_at_exlibris.co.il> wrote:
>Hi Chris,
>
>Try using :
>
>SET TERMOUT OFF
>SET FEEDBACK OFF
>
>Please post an update if it solves the problem ;-)
>
>B.R.
>
>Ariel Kirson.
>Ex Libris.
>
>

HiYa

set feedback off was the one ... thanks

FWIW set ver off -- gets rid of the variable substitution, and set feedback off gets rid of the line:  

PL/SQL procedure successfully completed.  

Here is my testing files :-)

manticora FIN_TEST #149 % cat bill.sql
spool &3
declare

job_nr            us_run_log.job_nr%type           := &1;
fnctn_id          us_run_log.fnctn_id%type         := '&2';
 

begin

    dbms_output.put_line('################## information################');

end;
/
manticora FIN_TEST #150 % cat t1
#!/bin/csh -fb
echo "about to run the PL/SQL ..."  

sqlplus -s / >file1 <<EOF_SQLPLUS
set serveroutput on
set ver off
set pause off
set feedback off
@bill 56 this that  

EOF_SQLPLUS
echo "PL/SQL complete, the result I got is " cat that.lst

---

Thanks again
:-)

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