Re: get package variables for every session

On 14 May 2005 23:32:18 -0700, "mkm" <kostya_at_malishich.com> wrote:

>Hi all experts. Need some help.
>I have a package like that:
>---
>CREATE OR REPLACE PACKAGE PACK1 AS
> VAR1 INTEGER;
> VAR2 INTEGER;
> ...
>END;
>CREATE OR REPLACE PACKAGE BODY PACK1 AS
> ...
>END PACK1;
>---
>Every user, when connected, sets the package var1, var2 for self to
>some values by this query:
>---
>BEGIN
> PACK1.VAR1:=111;
> PACK1.VAR2:=222;
>END;
>---
>
>I am loggin in as DBA and want to view all users connected and their
>var1, var2 values.
>Somthing like SELECT SID, VAR1, VAR2 FROM SOMETHING ...
>If package is not initialized, return NULL for var1,var2
>
>Any body know how to solve this?

No selects possible. Maybe by dumping session stacks using oradebug.

--
Sybrand Bakker, Senior Oracle DBA