Re: Need V$ Table from PL/SQL

Just remove owner name "sys" from the cursor definition.

I tried and it worked fine.

Let me know if this helped.

Chinna

Bill Canning <bill.canning_at_SanDiegoCA.NCR.COM> wrote in article <5us4j3$5be_at_rap.SanDiegoCA.NCR.COM>...
> I'm having a problem accessing Oracle v$ dynamic performance tables from
> inside PL/SQL (starting with v$parameter, but I also need others).
>
> Code looks something like this (I'm logged into SQL PLUS with
> dba privileges)...
>
>
> DECLARE
> local_name varchar2(64);
> local_value varchar2(512);
> CURSOR c1 is select name, value from sys.v$parameter;
> BEGIN
> OPEN c1;
> LOOP
> FETCH c1 into local_name, local_value;
> <more stuff here>
> EXIT WHEN c1%NOTFOUND;
> END LOOP;
> END;
> /
>
> I get compilation errors creating procedure 'PLS-00201: identifier
> 'SYS.V$PARAMETER' must be declared.
>
> I'm new to PL/SQL. Is this something obvious I'm doing wrong or
> is there a restriction on PL/SQL and v$ tables. If so, is there any
> work around?
>
> Thanks in advance,
>
> Bill Canning
> bill.canning_at_sandiegoca.ncr.com
>
>
  Received on Fri Sep 19 1997 - 00:00:00 CDT