Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.server -> select on V$SESSION from PL/SQL
Hi,
When I run the following sql statement ...
select program from v$session
... everything works well.
But when I include the following block in a PL/SQL package ...
begin
select program
into l_prg
from v$session
where audsid = l_adtsss;
exception
when NO_DATA_FOUND then
l_prg := 'Unknown';
end;
... I receive the error message: PLS-00201: identifier 'SYS.V_$SESSION' must
be declared
The user issuing the sql statement is the owner of the package, so I don't understand why it works in the first case and not in the second.
Thanks for your help,
Patrick J. Received on Mon Feb 04 2002 - 03:12:51 CST