Jump to content
Bency Mathew

How to check the function call is initiated from which DB Object

Recommended Posts

Hi team,

I have a function inside a package. this function is being called from many other packages, triggers, procedures etc. I wanted to have a mechanism to find out from where the call is getting initiated.

 

How this can be done

 

Kind Regards

Bency

Share this post


Link to post
Share on other sites

Hi Bency, and welcome to the forum!

Yhe only way to achieve this is to add code  that inserts the calling procedure into an audit table.

But this requires that you set a variable in the procedure and pass it to the SQL function as a parm.

But that is a kludge because a function can be executed standalone in sqlplus, outside of any procedure.

Hope this helps . . . 

Share this post


Link to post
Share on other sites

Create an account or sign in to comment

You need to be a member in order to leave a comment

Create an account

Sign up for a new account in our community. It's easy!

Register a new account

Sign in

Already have an account? Sign in here.

Sign In Now

×