Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.server -> Re: DBMS_OUTPUT.ENABLE doesn't work.

Re: DBMS_OUTPUT.ENABLE doesn't work.

From: Ken Nichols <knichols_at_mcsilo.ilo.dec.com>
Date: 1997/10/03
Message-ID: <3434AD63.6E68@mcsilo.ilo.dec.com>#1/1

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

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US