Re: Need V$ Table from PL/SQL

There's another possible reason for your problems. If you are using a stored procedure to select the data, you will often find that a query which works from SQLPLUS will not work from PL/SQL. This happens when your SELECT privileges on a table or view are "role-based", and weren't explicitly granted to your account. You may need to connect as SYS, and grant the SELECT privilege to yourself.

Hope this helped:)

Steve Johnson wrote:
>
> Bill Canning wrote:
> >
> > I'm having a problem accessing Oracle v$ dynamic performance tables from
> > inside PL/SQL (starting with v$parameter, but I also need others).
> >
 

>
> Change sys.v$parameter to sys.v_$parameter and it should work.
>
> Steve J.
 

-- 
The views expressed here are mine and do not reflect the official
position of my employer or the organization through which the 
Internet was accessed.