PL/SQL (MOSC)

MOSC Banner

How can a package procedure or function identify itself at runtime?

edited Feb 2, 2012 2:23AM in PL/SQL (MOSC) 3 commentsAnswered
Hello All,I am working on creating a common logging package that will be used across multiple applications.

One of the things that I would for this package to do is identify the current SCHEMA, PACKAGE (OBJECT), and COMPONENT (FUNCTION, PROCEDURE) being executed when it is invoked.

I know that you can get the SCHEMA / PACKAGE (OBJECT) for the error stack when dealing with exceptions, but I need something that can be used in non-exception contexts as well.
Additionally, I need that additional level of detail - the individual function/procedure being executed - not just the SCHEMA / PACKAGE information.

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