how can I tell what sql caused my trigger to fire

Author: asktom.oracle.com | Published: 1st May 2008 | Visited: 78 times | Add Comment
Filed in: Oracle FAQ

Hi, We have a database table from which the rows are deleted and we have no idea how is it happening. Users claim that they are not deleting it through application. I put an ondelete trigger on that table and stored the rows that were deleted in ...

Read Article

Sponsored Links

• [len:QOTD] Ready, Fire, Aim Is it really that taxing... - O'Reilly XML Blog Most of the time when I find a programmer struggling with XML, they are a relational database programmer or an object-oriented programmer, or both. We should have lined these guys u ...

• Referencing values in update trigger Tom, When a before update for each row trigger fires and a certain column was not set in the update statement, the :new value for the "certain column" appears to be set to the :old value by the time the trigger fires. Is there a way to determine ...

• DDL within a Trigger Everything I have ever read about triggers explicity states that DDL, because of an implicit commit, cannot be used within a trigger. I have, though, seen in blogs and other various places where people have claimed to have gotten it to work through ...

• Invoking a WCF Service from a CLR Trigger A Step by step guide to communicating with WCF from a CLR trigger in SQL Server ...

• Name of the table or name the trigger in a body of the trigger How can I get a name of the table to which this trigger belongs or a name of the trigger in a body of the trigger? Thanks in adva ...

• A lazy approach to fire a GridView RowCommand event from a child DropDownList control A lazy approach to fire a GridView RowCommand event from a child DropDownList con ...

• Invoking a WCF Service from a CLR Trigger A Step by step guide to communicating with WCF from a CLR trigger in SQL Server ...

• Strange Trigger Behaviour Hi Tom, I stumbled upon a trigger that, in my opinion, should be failing every time an insert is attempted on the table, but it does not. (Sorry for even asking about this trigger because its bad, wrong, ugly, <enter_you_attribute_here>, but I ju ...

• Deploying Sun Java Enterprise System on the Sun Fire T2000 Server using Solaris Containers (PDF) This article discusses how to consolidate enterprise infrastructure services in Sun Java Enterprise System--Web Server, Directory Server, Access Manager, Portal Server, Messaging Server, Calendar Server, and Communications Express--onto a single Sun Fire T2000 server, leveraging the enhanced suppor ...

• trigger problem Hi Tom, I have a 'test' trigger like this: <code> SQL> CREATE OR REPLACE PROCEDURE pr_valid 2 ( 3 p_object_name in varchar2 , 4 p_object_type in varchar2 , 5 p_object_owner in varchar2 6 ) 7 IS 8 - ...

Next: When is a commited transaction removed form the ITL