Re: Output from PL/SQL

Martin Jesterhoudt wrote:
>
> 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 ---
> -------------------------------------------------------------------------------
Solutuion1:

why not put set serveroutput on into your script like this:

SET SERVEROUTPUT ON
BEGIN
  ...
  dbms_output.put_line( ... );
  ...
END;
/

Solution2:
try to activate SERVEROUTPUT by using dbms_output.enable inside your code
begin
  dbms_output.enable( nnnnnnnn );
  ....
  dbms_output.put_line( ... );
  ....
end;
/

hope it helps. greetings from a sunny AUSTRIA.   franz.lindsberger_at_siemens.at Received on Fri Aug 22 1997 - 00:00:00 CDT