PeopleTools and Lifecycle Management - PSFT (MOSC)

MOSC Banner

Update trigger does not work - Urgent

edited Mar 12, 2012 7:58AM in PeopleTools and Lifecycle Management - PSFT (MOSC) 2 commentsAnswered
I had a problem as below:I had a trigger (Insert, update, delete) for my table. When I update data in correction mode (Update/Display All), the update trigger didn't work, only insert and delete could work. And there was a strange phenomenon, when I updated a row, there would be 2 rows in my audit table, one for Insert (new one) and one for delete (old one). The following is my trigger sql:
=============================================================
create or replace
TRIGGER DC_TR_AU_DC_SECONDMT_DAT
AFTER INSERT OR UPDATE OR DELETE ON PS_DC_SECONDMT_DAT
FOR EACH ROW
DECLARE
V_AUDIT_OPRID VARCHAR2(64);

Howdy, Stranger!

Log In

To view full details, sign in to My Oracle Support Community.

Register

Don't have a My Oracle Support Community account? Click here to get started.

Category Leaderboard

Top contributors this month

New to My Oracle Support Community? Visit our Welcome Center

MOSC Help Center