Re: spooling from PL/SQL

Or, you can use PRINT after the PL/SQL block.

Try this:

DECLARE
STR VARCHAR2(100);
BEGIN
SELECT 'Hello!' INTO :STR FROM DUAL;
END;
/
PRINT STR; Venkat wrote:
>
> USE DBMS_OUTPUT package
> Venkat
>

-- 
------------------------------------------------------------
Stanley Fung                 | Software Analyst
Mobile Data Solutions Inc.   | Direct Line: (604)207-6290
Suite 135                    | Tel:         (604)270-9939
10551 Shellbridge Way,       | Fax:         (604)270-1310
Richmond, B.C.               | E-Mail:      sfung_at_mdsi.bc.ca
Canada V6X-2W9               | http://www.mdsi-advantex.com
------------------------------------------------------------