Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.server -> Re: Environment within PL/SQL (like environment variables)
Jeremy wrote:
> Hi, we are looking to record any unhandled exceptions in any pl/sql code
> in a table.
>
> I guess by definition these then become "handled exceptions" ;)
>
> Would like to record (this is a web app) the IP address of the caller
> plus various other bits of information. I was just wondering if there
> are any system variables for example containing the name of the
> currently executing package.procedure ?
>
> --
> jeremy
>
> We use Oracle 9iR2 on Solaris 8 with the Oracle HTTP Server and
> mod_plsql
http://asktom.oracle.com/~tkyte/who_called_me/index.html
Hth,
Vladimir M. Zakharychev
N-Networks, makers of Dynamic PSP(tm)
http://www.dynamicpsp.com
Received on Wed Jun 28 2006 - 11:37:53 CDT