Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
![]() |
![]() |
Home -> Community -> Usenet -> c.d.o.server -> Re: SERVEROUTPUT Status
Igor Laletin wrote:
> Daniel,
>
> Daniel Morgan <damorgan_at_x.washington.edu> wrote
>
>>DBMS_OUTPUT does not belong in production code: Ever!
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?
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
![]() |
![]() |