Re: spooling from PL/SQL

Try:

PROMPT <string>

i.e.,

PROMPT Hello

You can also use SQL*Plus's silent mode to suppress the SQL> prompts. Simply invoke SQL*Plus with the -s parameter.

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.

-----== Posted via Deja News, The Leader in Internet Discussion ==----- http://www.dejanews.com/ Now offering spam-free web-based newsreading Received on Fri May 22 1998 - 00:00:00 CEST