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 -> Environment within PL/SQL (like environment variables)

Environment within PL/SQL (like environment variables)

From: Jeremy <jeremy0505_at_gmail.com>
Date: Wed, 28 Jun 2006 15:00:59 +0100
Message-ID: <MPG.1f0c9be9f9c3bb5698a228@news.individual.net> 





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


Received on Wed Jun 28 2006 - 09:00:59 CDT












Original text of this message













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