Re: Output from PL/SQL

From: Holger Heidenbluth <keeptool_at_swn.de>
Date: 1997/08/15
Message-ID: <33F45E5E.595A@swn.de>#1/1

Pavel David wrote:
>
> How can I display results from PL/SQL (within LOOP-FETCH block) to
> standart output ?
>
> P.David, davpav_at_mmr.cz

You may use the dbms_output package automatically installed with Oracle. There are procedures put and put_line for several data types. All outputs are written into a buffer. SQL*Plus displays the lines after execution if you have specified 'set serveroutput on'. Within your application you may use the procedure dbms_output.get_lines.

You can also see the outputs (and much more) in our tool Hora. For a free 30 day trial version see www.keeptool.swn.de.

Regards
Holger Heidenbluth Received on Fri Aug 15 1997 - 00:00:00 CDT