Re: Previously Undiscovered Oracle Gold

DA Morgan wrote:
> Well at least to me.
>
> I was looking around the OWA_UTIL package over the weekend and found
> the WHO_CALLED_ME procedure.
>
> It can be called in a stored procedure and returns the owner,
> name, line number, and caller object type.
>
> Could be a great addition to an error handling procedure.
>
> There is a simple demo at www.psoug.org in Morgan's Library.
>
> Daniel Morgan
> www.psoug.org

I did not know about this one, but I can't say that it surprises me either. The DBMS_DEBUG package can return the call stack from any proc that you have stepped into. So the functionality has existed in one form or another....

Cheers,
Brian

-- 
===================================================================

Brian Peasland
oracle_dba_at_nospam.peasland.net
http://www.peasland.net

Remove the "nospam." from the email address to email me.


"I can give it to you cheap, quick, and good.
Now pick two out of the three" - Unknown