Problems With Using V$SESSION Procedure

Hi,

The following anonymous compiles:

declare
a v$session.SID%type;
begin
select min(SID) into a from v$session;
dbms_output.put_line(a);
end;

However, take the above and put it in a stored procedure, and it does not compile, giving the error "PLS-00201: identifier 'V$SESSION' must be declared":

create or replace procedure foo is
a v$session.SID%type;
begin
select min(SID) into a from v$session;
dbms_output.put_line(a);
end;

Now this problem occurs only with the V$ views, but not with other system tables or views such as ALL_ARGUMENTS, ALL_TABLES, etc.

The above code was compiled under an account that has been assigned the DBA.

Help?!

Thanks,
Salaam Received on Mon Aug 12 2002 - 12:48:25 CDT