Re: Global constants/variables

Hi,

I have found that storing constants in a package specification is definately the easiest way of managing them.

There is one problem though - making changes to a GLOBAL package spec will invalidate all the packages and procedures that reference it (i.e. all those that use the constants). This can be a pain if you have lots of stored procedures affected. Apart from that, it works really well.

Steve

DUSTY LIVES wrote:

> Everyone;
>
> Can someone explain how/where to store a value for a constant
> at the database level? I want to create/add to an initialization
> file that all users will have as a global constant (let's say
> MAX_DAY_REMAINING = 10). This way all one would have to do would
> be to change the value (if needed), and the new value would be
> available at next db startup (ie. init.ora)?
>
> Dusty
Received on Mon May 18 1998 - 05:39:32 CDT