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

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.

"Steve Long" <steven.long_at_erols.com> wrote in message news:9c2leu$5d1$1_at_bob.news.rcn.net...
> write them to a table
>
> "Rick Westmacott" <r_westmacott_at_hotmail.com> wrote in message
> news:KC4F6.49715$EN.1573658_at_news1.rdc1.sdca.home.com...
> > I am doing some application error handling and I need to find a way to
> > retrieve passed parameters and associated values from within a pl/sql
 common
> > error procedure. This error procedure will be called in the WHEN OTHERS
 of
> > all our application modules and I don't want to pass the input
 parameters
 to
> > the error routine because we would have to make that change to roughly
 1000
> > modules. I can pick up the calling package/procedure name but I also
 need
> > the calling parameters/values. We are using the Oracle Web server to
> > generate our web pages and are using the POST method.
> >
> > Does anyone know how this can be done? I know this information must be
 kept
> > somewhere (besides wrb.log), but I can't seem to locate it. Maybe V$
> > tables?
> >
> > Any help would be appreciated.
> >
> > Rick
> >
> >
>
>
Received on Mon Apr 23 2001 - 21:31:34 CDT