Re: Problems With Using V$SESSION Procedure

"Salaam Yitbarek" <yitbsal_at_yahoo.com> wrote in message news:77439c33.0208120948.6e44589f_at_posting.google.com...
> 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

Yawn.

Paul Received on Mon Aug 12 2002 - 13:49:09 CDT