Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.misc -> Re: spooling from PL/SQL
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;
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
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