How Can I find out who called me or what my name is: "Many times we are asked 'in a procedure/function, can I find out who called me' or 'can I dynamically figure out the name of the procedure or package that is currently executing'.
You can find it in the call stack returned by dbms_utility.format_call_stack."
