Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
![]() |
![]() |
Home -> Community -> Usenet -> c.d.o.server -> Re: UTL_File
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
![]() |
![]() |