Re: Identifying the executing PL/SQL procedure when an Oracle error occurs

From: Sybrand Bakker <postbus_at_sybrandb.demon.nl>
Date: Thu, 04 Apr 2002 19:17:09 +0200
Message-ID: <7j2pau8i6no3ohrubb85e8dr51l0vsjb5m@4ax.com>

On 4 Apr 2002 06:51:42 -0800, hoke_at_gse.harvard.edu (Ken Ho) wrote:

>I should have been more specific. Is there any way to get the
>procedure (and possibly enclosing package) name without assigning it
>manually like Daniel suggested (which is what I'm already doing)? Is
>that information already kept dynamically in a table which Oracle
>automatically maintains?
>
>-Ken Ho
>hoke_at_gse.harvard.edu
>

use dbms_utility.format_error_stack in your exception handler. Tom Kyte also has an utility on his website.

Hth

Sybrand Bakker, Senior Oracle DBA

To reply remove -verwijderdit from my e-mail address Received on Thu Apr 04 2002 - 11:17:09 CST