GeekArticles
FAQ
Oracle FAQhow can I tell what sql caused my trigger to fire
Author: asktom.oracle.com |
Published: 1st May 2008 |
Visited: 78 times |
Add CommentFiled in: Oracle FAQHi,
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
Related Articles
• [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 ...
• 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 ...
• 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 - ...