Human Capital Management - EBS (MOSC)

MOSC Banner

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

Howdy, Stranger!

Log In

To view full details, sign in to My Oracle Support Community.

Register

Don't have a My Oracle Support Community account? Click here to get started.

Category Leaderboard

Top contributors this month

New to My Oracle Support Community? Visit our Welcome Center

MOSC Help Center