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

Home -> Community -> Usenet -> c.d.o.misc -> retrieving the location of a database trigger call..

retrieving the location of a database trigger call..

From: Nigel Curtis <cn_curtis_at_runbox.com>
Date: 27 Apr 2007 03:22:11 -0700
Message-ID: <1177669331.592534.229060@o40g2000prh.googlegroups.com> 






Hi - in a 10g Oracle 'Before Insert or Update' trigger is there any
way of find the source of the insert/update...?  That is, the name of
any background process, SQL*Plus script  or form which may have done
the insert/update..?



If such information isn't lost I'd like to try and use it as a
condition within the trigger but can't see any way of retrieving it.



many thanks, nigel
Received on Fri Apr 27 2007 - 05:22:11 CDT












Original text of this message













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