Hi all,
I was trying to select v$session table from a procedure, and when I'm compiling it, it kept getting me errors.
I was trying to do this...
Insert into(.......)
select.....from v$session
where....
group by....
LINE/COL ERROR
-------- -----------------------------------------------------------------
65/3 PL/SQL: SQL Statement ignored
67/65 PLS-00201: identifier 'SYS.V$SESSION' must be declared
Is there any pre-requirement?