Determine the caller procedure in PL/SQL

[mpegjunkie]

Hi,
My question is PL/SQL related.
I have a pkg_tool-Package, that has useful functions and is being called from multiple other packages.
One function should now behave different depending on the caller procedure.
Now, for avoiding a parameter to identify the caller package, is there a way for a procedure to "trace" or to determine the caller package or caller procedure of it?
We're using Oracle 10g (10.2.0.3) Enterprise.
Thanks in advance,
Roman

 

[Dagon]

Try dbms_utility.format_call_stack.

 

[ChrisHunt]

I would recommend adding the extra parameter - it'll make the function easier to maintain in the future if the output it gives depends solely on the input it receives.

I'd hate to debug something that digs around in the call stack and acts differently depending on what it finds there.

-- Chris Hunt
Webmaster & Tragedian
Extra Connections Ltd

 

[mpegjunkie]

Thank you Dagon and Chris,
I will prove both suggestions.
Regards,
Roman