Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.server -> 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 ------------------------------------------------------------Received on Wed May 20 1998 - 00:00:00 CDT