Re: V$SESSION IN PACKAGE

Stephan Hartmann wrote:
>
> Hello,
>
> I have create a user TEST, granted them the plustrace role (because of
> V$SESSION).
>
> When I make a simple SQL-Statement SELECT * FROM V$SESSION everything works
> fine.
>
> When I try to access the V$SESSION View from inside a package
> I get an error PSL-00201, SYS.V_$SESSSION must be declared.
>
> What is missing, or how is it possible to access the V$Session View ?
>
> bye
> Stephan

See

http://govt.oracle.com/~tkyte/Misc/RolesAndProcedures.html

HTH

-- 
===========================================
Connor McDonald
http://www.oracledba.co.uk

We are born naked, wet and hungry...then things get worse