Re: Storing application variables

From: Sybrand Bakker <postbus_at_sybrandb.demon.nl>
Date: Wed, 05 Jan 2000 21:02:10 GMT
Message-ID: <3873b0ec.10326999@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 Wed Jan 05 2000 - 15:02:10 CST