Identify that your function was called from a form

[kuhlkmk]

Hello - we have a function written in pl/sql. This function will either be called by another pl/sql procedure, or it may be called by an oracle form (6i). Is there anyway, while I am in the function, to tell who/what is calling it? We'd like the error handling to perform differently if it was called from a form vs another procedure. If not - we'll handle it inside the form. I was just wondering if there might be another approach. Thanks!

 

[carp]

You might try adding an argument to the function. Then the calling routine can supply a value (e.g., 'FORM' or 'PROCEDURE'). The function can reference the value of the argument to govern its behavior.