Problem with the v$session view.

Why is it that from SQL*Plus I can successfully do:

SELECT username,osuser,program,machine
FROM v$session
WHERE audsid = USERENV('SESSIONID')

But if I do a similar select into PL/SQL variables in a stored procedure (while
logged on as the same Oracle user) I get the following compile error:

PLS-00201: identifier 'SYS.V_$SESSION' must be declared

I'm guessing that it's some permission problem but I haven't been able to figure it out. Any ideas ?

Thanks

Ric Received on Thu Dec 11 1997 - 00:00:00 CST