Re: Output from PL/SQL

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

At the SQL> prompt, set serveroutput on. In your script, use the dbms_output package to dump stuff to output. rtfm on the limitations of the package. The Ant book has a really good overview of the stuff and the packages themselves have docs in the header.

-- 
Brian Martin		BOFH, Programmer
LAB-Interlink		UNIX is GOD mispelled
Medical Robotics	Does Oracle have the answer?

bcmartin_at_labinterlink.com

The sound of one hand clapping is the same as that of
a tree falling unheard in a forest.