Topic: SQL*Plus and PL/SQL >> Help on triggers
|
Disclaimer: The purpose of all dbapool forums including OCP and Other Oracle Certification forums is to help each other with specific issues but not to share dump and copyrighted exam content, materials or intellectual property.
You may review the entire Oracle Certification Program Candidate Agreement online Here.
|
|
|
|
| Gai |
Posted: Jan 02, 2007 08:22:33 AM |
Total Post: 8
Joined: Aug, 2006
|
| Letz say I want to audit a table T1, i.e if any value of a column c1 of T1 is changed, I want to record the changes in the table Change1. So I write a trigger on T1 (on insert, update and delete). Suppose one of the updates to C1 of T1 failed, I want to include that also in Change1. Will the trigger get executed even if the DML operation fails? I would like to know a little more about trigger execution pattern. Thanks a bunch. |
|
|
 Prakash |
| Posted: Jan 03, 2007 11:46:47 PM |  |
|
Total Post: 112
Joined: Aug, 2006
|
If a DML operation fails , this trigger will not record.Only successfull operations will be logged. For failed operations ,Enable fine grain auditing.
|
|
|
|
|
| Time Zone: EDT |
Send this thread to your friend |
|
|
|
|
Forum Rules & Description
Who Can Read The Forum? Any registered user or guest
Who Can Post New Topics? Any registered user
Who Can Post Replies? Any registered user
|
| |
Get FREE Magazines
|
Top 10 Forum User
|
| Murtuja Khokhar | 857 |
| Mohammed Taj | 746 |
| positive fanatic | 483 |
| Jayanta Sur | 479 |
| Vigyan Kaushik | 386 |
| Gopu Gopi | 327 |
| Gitesh Trivedi | 322 |
| Vinoth Kumar | 264 |
| neeraj sharma | 258 |
| Ramesh Jois | 246 |
|
|
