Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.server -> Re: Global constants/variables

Re: Global constants/variables

From: Steve McAreavey <stephen.mcareavey_at_bt.com>
Date: Mon, 18 May 1998 11:39:32 +0100
Message-ID: <35600FE4.D3AF8AB1@bt.com>


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

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US