Re: spooling from PL/SQL

USE DBMS_OUTPUT package
Venkat

>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.
Received on Wed May 20 1998 - 00:00:00 CDT