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: SERVEROUTPUT Status

Re: SERVEROUTPUT Status

From: Daniel Morgan <damorgan_at_x.washington.edu>
Date: Wed, 11 Feb 2004 23:55:25 -0800
Message-ID: <1076572478.749135@yasure>


Igor Laletin wrote:

> Daniel,
>
> Daniel Morgan <damorgan_at_x.washington.edu> wrote
>

>>DBMS_OUTPUT does not belong in production code: Ever!

>
>
> I think it's wrong. Like probably the most of the statements with the
> word 'ever'. DBMS_OUTPUT has two main restrictions: buffer size and
> line size. They are not a reason not to use it though. Ever! :) If
> your output fits in, it's the easiest way to go.

Go where? To a monitor in a room that no one ever looks at?

> The output doesn't disappear in nowhere, normally it goes to a
> logfile. And Syltrem did mention this. I don't know where you get your
> 'A simple "clear screen" and your record is gone' from.

If the OP did I missed it. But great it is in an operating system file. Will anyone read it? Maybe. Can you graph it? No. Can you check deltas like last year to this year? No.

>>INSERT INTO <table_name> is overkill?

>
>
> You need:
> - create table and indexes
> - code autonomous transaction if there is need for non-transactional
> output
> - grant privileges
> - define, code and monitor purge procedure
> - provide easy access to the log table (reports, views).

Ok now you got it from five seconds up to 15 or 20.

> All these instead of dbms_output.put_line, which gives the same result
> and the same persistency.

And is worthless, or nearly so thereafter.

> I'm not saying use dbms_output when ever you need the output from
> pl/sql. But it's quite appropriate in the Syltrem's situation.
>
> Regards,
> Igor

We must agree to disagree.

-- 
Daniel Morgan
http://www.outreach.washington.edu/ext/certificates/oad/oad_crs.asp
http://www.outreach.washington.edu/ext/certificates/aoa/aoa_crs.asp
damorgan_at_x.washington.edu
(replace 'x' with a 'u' to reply)
Received on Thu Feb 12 2004 - 01:55:25 CST

Original text of this message

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