retrieve 0 records from SESSION_ROLES in package function - Help

I wrote a packaged function that retrieve and count the number of roles of a session:

In the package function the cursor

    cursor c_role is

       select role from SESSION_ROLES;

was used to for the purpose.

To my surprise, the function always return zero count.

If the cursor was changed to retrieve from any other table it works, I tried it ok for USER_ROLE_PRIVS. Now why does it not works for SESSION_ROLES ?

I have tried using the same function as named function in a PL block and it works !

Now how can i get it to work in packaged procedure.

Any help is appreciated.

Peter Yu Received on Sun Aug 05 2001 - 22:07:12 CDT