Re: Problems With Using V$SESSION Procedure

Thank you for your replies.

Salaam

yitbsal_at_yahoo.com (Salaam Yitbarek) 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
Received on Tue Aug 13 2002 - 06:45:27 CDT