Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
![]() |
![]() |
Home -> Community -> Usenet -> c.d.o.server -> Re: DBMS_OUTPUT.ENABLE doesn't work.
dbms_output.enable() does not set serveroutput on. It only sets the
buffer size for
dbms_output put and get statements. Also, by setting serveroutput on you
have also
enabled dbms_output by default with the default buffer size.
Eddy Setiawan wrote:
> Hi,
>
> I'm trying to use the DBMS_OUTPUT package to write some reports,
> but in every new session, the command SET SERVEROUTPUT ON need
> to be issued. According to PL/SQL programming book by O'Reily,
> the DBMS_OUTPUT.ENABLE should do the job. I've tried that, but
> it doesn't seems to work. Is there anything that I missed? Your
> kind help is appreciated. TIA.
>
> Regards,
> Eddy Setiawan
> <setiawan_at_singnet.com.sg>
Received on Fri Oct 03 1997 - 00:00:00 CDT
![]() |
![]() |