Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.server -> Re: spooling from PL/SQL

Re: spooling from PL/SQL

From: Stanley Fung <sfung_at_mdsi.bc.ca>
Date: 1998/05/20
Message-ID: <35635B7B.18AE@mdsi.bc.ca>#1/1

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

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US