PL/SQL (MOSC)

MOSC Banner

trigger AFTER SERVERERROR ON DATABASE

edited Nov 23, 2011 10:30PM in PL/SQL (MOSC) 2 commentsAnswered
In our instalation, we control maximum IO or CPU call usage using profiles. We are using "after servererror" event to capture problematic statements.

But if triggering event is in between a stored procedure, the trigger returns the procedure call and not the triggering statement.

Is there any way to catch the effective statement but not the stored procedure where it is contained?

Thanks,

Carlos Julio Peixoto

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