Creating a Trigger Using Oracle Enterprise Manager

From: Paul Izzo <paul.izzo_at_mosca-ag.com>
Date: 31 Jan 2005 02:08:29 -0800
Message-ID: <1107166109.551998.149670@z14g2000cwz.googlegroups.com>

I'm looking to create a trigger using the Oracle Enterprise Manager. I want a table feild to be updated based on an event from another table.

I have 2 tables (PPLP and PAWU) the first table (PPLP) has the following relevent fields "Item_Nr" and "Correction_Date".

The second table (PAWU) contains "Item_Nr" and "Adjustment_Status".

I want a trigger to occur when the Correction_Date column is updated in table PPLP I want the same associated Item_Nr in table PAWU Adjustment_Status to be updated from "00" to "02".

I've stepped through the Oracle Enterprise Manager's menu for creating a trigger but I'm stuck on the advanced tab with the referencing fields Old as:, New as: and the Condition feild.

Here's the SQL statement that I have so far:

CREATE TRIGGER "MOSCA"."PPLP_PAWU_UPDATE" BEFORE UPDATE OF "Correction_Date" ON "MOSCA"."PAWU" FOR EACH ROW Received on Mon Jan 31 2005 - 04:08:29 CST