From: "Daniel A. Morgan" <dmorgan@exesolutions.com>
Newsgroups: comp.databases.oracle.server
Subject: Re: determining parameters and values within PL/SQL error handling
Date: Mon, 23 Apr 2001 22:11:27 -0700
Organization: EXE
Message-ID: <3AE50AFF.4FA8843D@exesolutions.com>
X-Mailer: Mozilla 4.7 [en] (WinNT; I)
X-Accept-Language: en
MIME-Version: 1.0
References: <KC4F6.49715$EN.1573658@news1.rdc1.sdca.home.com> <9c2leu$5d1$1@bob.news.rcn.net> <aA5F6.49758$EN.1589643@news1.rdc1.sdca.home.com>
Content-Type: text/plain; charset=us-ascii
Content-Transfer-Encoding: 7bit
Cache-Post-Path: yabetcha.drizzle.com!unknown@ava35.drizzle.com
X-Cache: nntpcache 2.4.0b2 (see http://www.nntpcache.org/)
X-Complaints-To: newsabuse@supernews.com
Lines: 17




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