I have created a trigger on a table to write information to a history table,
and I've run into some behavior that's confusing me...some clarification
would be greatly appreciated.
My trigger code is as follows:
CREATE OR REPLACE TRIGGER endb.budget_total_amt_hist_trg
BEFORE UPDATE of total_amt_auth, expiration on endb.budget
FOR EACH ROW
BEGIN
<code_to_rollover_data_to_history_table>
END;
Now my confusion lies in the fact that the trigger is supposed to fire ONLY
when either the total_amt_auth column OR the expiration column gets updated.
Now, of course it works fine when we update either of those columns. But
the problem/confusion is why is it also firing when we update other fields
in the table also?? If we update any column other than those two the
trigger still fires. What am I doing wrong or missing/forgetting???
-::YEX::-
Robert D. Yexley, SSgt
Air Force Institute of Technology
Applications Services Division (SCA)
Oracle DBA & Programmer
<)))><
[EMAIL PROTECTED]
DSN - 785-6565 x-4268
Commercial - (937) 255-6565 x-4268
_________________________
"God who gave us life gave us liberty.
Can the liberties of a nation be secure
when we have removed a conviction
that these liberties are a gift of God?
Indeed I tremble for my country when
I reflect that God is just, that his
justice cannot sleep forever."
- Thomas Jefferson, 3rd US President
______________________________
--
Please see the official ORACLE-L FAQ: http://www.orafaq.com
--
Author: Yexley Robert D SSgt AFIT/SCA
INET: [EMAIL PROTECTED]
Fat City Network Services -- (858) 538-5051 FAX: (858) 538-5051
San Diego, California -- Public Internet access / Mailing Lists
--------------------------------------------------------------------
To REMOVE yourself from this mailing list, send an E-Mail message
to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(or the name of mailing list you want to be removed from). You may
also send the HELP command for other information (like subscribing).
