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: Suresh Bhat <suresh.bhat_at_mitchell-energy.com>
Date: Fri, 22 May 1998 19:33:32 GMT
Message-ID: <01bd85c8$98db3c60$a504fa80@mndnet>


I think the globals declared in the package can be seen in SQL*Plus only if any of the procedure/function in package is called.

suresh.bhat_at_mitchell-energy.com

Steve McAreavey <stephen.mcareavey_at_bt.com> wrote in article <35600FE4.D3AF8AB1_at_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 Fri May 22 1998 - 14:33:32 CDT

Original text of this message

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