Re: spooling from PL/SQL

From: Chris Eastwood <c.eastwood_at_gu.edu.au>
Date: Wed, 20 May 1998 06:37:46 GMT
Message-ID: <6jttoa$rhg$1_at_nkraken.itc.gu.edu.au>


HiYa

[Quoted] I use dbms_output Eg

set serveroutput on
declare
-blah
begin
dbms_output.enable(1000000);

--blah ... blah
--then

dbms_output.put_line('The following message contains information about ');

--yadda

end;

becareful, there is a limmit of a Meg output file :-(

In article <35627876.2913_at_dd.vaz.tlt.ru>, "Kapustin A.G." <kag_at_dd.vaz.tlt.ru> wrote:
>Hello!
>
>Yes, 'SET FEEDBACK OFF' works fine -
>Messages like 'PL/SQL Procedure successfully...' don't appear after it.
>
>But I have other question:
> How can I put to pl/sql-spool, for example, simple phrase ('Hello!')?
>
>Assume I have pl/sql block:
>
> DECLARE
> STR VARCHAR2(100);
> BEGIN
> SELECT 'Hello!' INTO STR FROM DUAL;
> END;
> /
>
>Before executing it, I say: 'SET FEEDBACK OFF', 'SET HEADING OFF',
>'SPOOL sp.lst'.
>Then I execute block, and - empty output.
>
>How can I put 'Hello!' to spool?
>Decisions like 'Try using SQL, not PL/SQL' - not a good idea.
>
>
>Alexander G. Kapustin
>
>Russia, Togliatti
>AVTOVAZ Inc.
>=================================================
>
>Ariel Kirson 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.

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 Wed May 20 1998 - 08:37:46 CEST

Original text of this message