get package variables for every session

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? Received on Sun May 15 2005 - 01:32:18 CDT