Re: determining parameters and values within PL/SQL error handling

From: Daniel A. Morgan <dmorgan_at_exesolutions.com>
Date: Mon, 23 Apr 2001 22:11:27 -0700
Message-ID: <3AE50AFF.4FA8843D@exesolutions.com>

Rick Westmacott wrote:

> Thanks for the reply Steve,
>
> That is the obvious solution, but I am looking for a solution where I don't
> have to modify hundreds of stored procedures.

Put that notion under your pillow and hope the tooth fairy comes.

My suggestion would have been to pass them to global variables available to the error-proc. But I can think of no way you can get them without modifying the procedures.

Daniel A. Morgan Received on Tue Apr 24 2001 - 00:11:27 CDT