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: UTL_File

Re: UTL_File

From: Maxim Demenko <mdemenko_at_arcor.de>
Date: Wed, 27 Jul 2005 18:33:33 +0200
Message-ID: <42e7b867$0$29076$9b4e6d93@newsread2.arcor-online.net>


Mark D Powell schrieb:
> example of something you shouldn't
> do. That is you should not be using dbms_output to buffer data to be
> printed using utl_file.

Well, Mark, if you mean , "it should never be designed" - i'm on your side, if you however mean "it should never be done" - i disagree. In a well designed program dbms_output usually has no place, as it serves only debugging purposes. It can have very undesired side effects if you leave calls to dbms_output in production code. On the other side calls to utl_file are legitimated in many cases - the 2 packages have simply different scope of use. In some cases hovewer, it can be reasonable in the debugging process ( it depends simply on debugging approach ) to redirect the stderr from terminal to file , which can be done of course with spool, but can be also done with utl_file. I don't see any valueable cons/pros for both methods .

Best regards

Maxim Received on Wed Jul 27 2005 - 11:33:33 CDT

Original text of this message

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