Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.server -> Re: Environment within PL/SQL (like environment variables)

Re: Environment within PL/SQL (like environment variables)

From: Vladimir M. Zakharychev <vladimir.zakharychev_at_gmail.com>
Date: 28 Jun 2006 09:37:53 -0700
Message-ID: <1151512673.587840.130720@b68g2000cwa.googlegroups.com>

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

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US