Using 'v$' objects from within a stored procedure
Hi, we're trying to create a concurrent program based on a database procedure to kill invalid logins that happen during a major patching event. When I try to create a stored procedure referencing v$access and v$session, I'm unable to compile the stored procedure as I get an error quoting the objects don't exist. I'm logged in as 'APPS' and this is our lower environment. I can run the 'Select' statements on these objects standalone without any issues but can't seem to create a database procedure. Our goal is to create a concurrent program that would be run on-demand to