Re: Single log for several procedures

There is a utility package called UTL_FILE that allows you to open/close/write/append etc... to a file. However, it is only available in version 7.3 or later. You can look up information on the CD: Oracle's Product Documentation Library Release 1.0.16, it's in Chapter 8 somewhere.

Laurie

-- 
+-------------------------------------+-----------------------------+
| Laurie J. Kirsh                     | Oracle DBA/Design/Developer |
| lkirsh_at_itsc.org  			  | Integration Systems Analyst |
| Lockheed Martin                     | ITSC project                |
| 301-982-1113				  | College Park, Maryland      |
 +-------------------------------------+-----------------------------+
|Opinions are mine and do not necessarily reflect those of          |
|Lockheed Martin Corporation.                                       |
+-------------------------------------------------------------------+
"Idiots are always more resourceful than geniuses.." -me

Tom Hanstra <hanstra.1_at_nd.edu> wrote in article <338C7460.5D69_at_nd.edu>...


> I am writing a number of related PL/SQL procedures and I would

> like to create one audit trail/log file to cover all of the various

> procedures.  What is the best way to do this?  I basically want to 

> always append to the same file, but do I have to open and close the

> file each time from each procedure and worry about one procedure

> over-writing another?

> 

> Thanks for any help or advice.  Please email replies.

> 

> Tom Hanstra

> ------------------------------------------------------------------------

> Thomas A. Hanstra                        Phone: (219)631-4686

> Office of Information Technologies       Email: hanstra_at_puck.cc.nd.edu

> University of Notre Dame                 

> Room G011 Computing Center/Math Building 

> Notre Dame, IN  46556

> ------------------------------------------------------------------------

>