Re: Need V$ Table from PL/SQL

change sys.v$parameter to v$parameter..

it worked for me..

let me know if this helped,

Chinna

doid <doid_at_usa.net> wrote in article <34194767.3C0E_at_usa.net>...
> 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.
>
  Received on Wed Sep 24 1997 - 00:00:00 CDT