Re: Output from PL/SQL

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

dbms_output.put( 'Some ' );
dbms_output.put_line( 'text');
dbms_output.put_line( 'Some more text');

The output will be:

Some text
Some more text

But you must SET SERVEROUTPUT ON SIZE nnnnnnn before it will work (put it in the LOGIN.SQL file).

-- 
Tomm Carr
---- ----
Hunting for a job is like hunting for an elephant.
If you're not *very* careful, you might find one!