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