Re: spooling from PL/SQL

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