Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
![]() |
![]() |
Home -> Community -> Usenet -> c.d.o.server -> Re: DBMS_OUTPUT.ENABLE doesn't work.
Hello Eddy,
One easy way around this is to put the command in your login.sql file. So, adding the line
SET SERVEROUTPUT ON SIZE 1000000 should relieve you from having to specify it every time you start a session. You can specify it for all users by putting the command into glogin.sql.
Also, if you're running Oracle 7.3, look at your release notes on disk; they've added many useful options to SET SERVEROUTPUT ON.
Maybe this will help.
Ken
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
![]() |
![]() |