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

Home -> Community -> Usenet -> c.d.o.misc -> Re: Storing application variables

Re: Storing application variables

From: Thomas Olszewicki <ThomasO_at_cpas.com>
Date: Sat, 08 Jan 2000 06:53:43 GMT
Message-ID: <X9Bd4.9095$eQ2.268077@news1.rdc2.on.home.com>


Sybrant,
Your solution will work only for the duration of the connection. NT registry is a permanent storage.
Oracle is a database. Why not store these variables values in a table?

Thomas

"Sybrand Bakker" <postbus_at_sybrandb.demon.nl> wrote in message news:3873b0ec.10326999_at_news.demon.nl...
> On Wed, 05 Jan 2000 20:45:08 GMT, jdefreitas_at_my-deja.com wrote:
>
> >Hi all.
> >
> >I need to store application-specific variables for some
> >stored procedures I've written for Oracle 8. I'm basically looking
> >to be able to perform something like the following:
> >
> >SELECT <my_application_variable>
> >FROM dual;
> >
> >Its analagous to storing application parameters in an NT registry
> >string, but somewhere in the Oracle data dictionary tables. Thanks!
> >
> >John G. de Freitas
> >
> >
> >
> >Sent via Deja.com http://www.deja.com/
> >Before you buy.
>
> If you create a package with those variables, they will be globally
> accessibly to all pl/sql in your session.
> You can't modify the datadictionary yourself. If you do that, you will
> loose support.
>
Received on Sat Jan 08 2000 - 00:53:43 CST

Original text of this message

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