Re: global variables in package

Maybe make SID a part of the composite log file name ?

Rolf Hauck wrote:

> hi all,
> we have created a package with procedures, which are called from an
> external program. Inside the procedures a logfile of performed actions
> is written with the utl_file package. The filename for the logfile was
> hard coded.
> Now the customer has installed several instances of the same application
> on the same machine (different databases). We don't want the messages to
> be merged into one logfile, but want to make the filename configurable
> from a db entry. But we want to avoid re-reading this config entry each
> time we want to write something into the logfile. What is the largest
> scope a global variable in a package can have?
> Of course we can clone our sources for the package and hard code the
> path for every copy... but that doesn't sound too nice, does it?
> Any idea?
>
> Thanks a lot
> Rolf
Received on Thu Aug 27 1998 - 02:47:32 CDT