Storing these results in a single row db table and allowing access to
this table through PL/SQL package functions (which do the SELECT and
RETURN) might be one solution.
regards,
M. Armaghan Saqib
- SQL PlusPlus : Add power to SQL Plus command line
- SQL Link for XL : Integrate Oracle with XL
- Oracle CBT with sample GL (Triggers and Forms Source Code included.
Download free: http://www.geocities.com/armaghan/
Njål Ekern <n.a.ekern_at_usit.uio.no> wrote in message
news:3858C809.85536F92_at_usit.uio.no...
>
> Hi!
>
> We have a system with a lot of pl/sql packages. We are running Oracle
> 8.0.6
> The possibility of having persistent global variables in the package
> specification available to the user throughout his/hers session is
very
> useful. But now we want something 'more general'. We want all users to
> have access to the same variables and their values, not having their
own
> private set.
>
> I.e. we want the db-startup-script to call a pl/sql procedure. The
> procedure will do some complicated and time-consuming estimations, and
> then we want it to store the results in some variables that will be
> readable for every user session.
>
> Are there any solutions for this kind of sharing variables between
> sessions?
>
> We have looked at packages with Pragma 'serially reusable'. Here the
> variables are stored in the SGA and initialised every time the package
> is called. We want something like a package stored in the SGA which
are
> initialised once and then all the variables in the package and their
> values can be read by pl/sql-programs ran by any session.
>
> Are there any solutions for this? Any ideas will be appreciated!
>
> Regards, Njål
> n.a.ekern_at_usit.uio.no
Sent via Deja.com http://www.deja.com/
Before you buy.
Received on Thu Dec 16 1999 - 05:17:13 CST
