Re: Output from PL/SQL block
From: Tim Smith <tssmith_at_netcom.com>
Date: Mon, 11 Oct 1993 14:53:09 GMT
Message-ID: <tssmithCEqMoL.2Cx_at_netcom.com>
Date: Mon, 11 Oct 1993 14:53:09 GMT
Message-ID: <tssmithCEqMoL.2Cx_at_netcom.com>
In article <1993Oct11.091541.20829_at_lssec.bt.co.uk> iparkin_at_iris.bt.co.uk writes:
>>Does anyone know how to produce output from a PL/SQL block
>>without SELECTing into a temporary table ?
>
>This is possible in a limited way by embedding the PL/SQL within a 3GL.
If you are using O7, use the DBMS_OUTPUT package routines, along with SET SERVEROUTPUT ON in SQL*Plus or SQL*DBA. There is also a pipes package that would let you write to a file (or print to the screen).
With V6, you'll have to use temp tables.
--Tim (tssmith_at_netcom.com) Received on Mon Oct 11 1993 - 15:53:09 CET