Re: Output from PL/SQL

On Fri, 15 Aug 1997 10:32:21 -0500, Tomm Carr <tommcatt_at_geocities.com> 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');
>
>But you must SET SERVEROUTPUT ON SIZE nnnnnnn before it will work (put
>it in the LOGIN.SQL file).

The problem is that, with large cursors, the outputsize will not be sufficient. Rather nasty problem, which I've been involved with.

• Martin Jesterhoudt ---
• martinj(replace this by @)worldonline.nl ---

  ---