INSTEAD of UPDATE Trigger on VIEW not firing
67058May 26 2003 — edited May 26 2003I have create a VIEW on three tables. I have created INSTEAD OF UPDATE trigger on the view. In the Trigger, I am taking the new values and storing into a log table. When ever I update a record in the base table, I see new values in the view. But I don't see any values in the Log table. So I think the Trigger is not firing. I turned on the trace and did not see any trigger being called. I checked USER_TRIGGERS and the trigger status is enabled and valid. I am running 9.02 database. Could any one tell me what I am doing wrong here. I appreciate your help.
Thanks.