We value your feedback.
Take our survey and automatically be enter to win anyone of the following:
Yeti Cooler, Amazon eGift Card, and Movie eGift Card!
create or replace TRIGGER "MY_BU" BEFORE UPDATE ON MY FOR EACH ROW declare ln_POP_MY_ID number; BEGIN if(:new.FRR_ID =2)then --MY_GEN_XREF_V (BD_SRC_SEC) UPDATE BD_SRC_SEC SET FRR_ID=2 WHERE (SRC_ID = :new.MY_ID -- MY_ID (SRC_ID) OR VALUE_ID = :new.MY_ID ) -- GEN_ID (VALUE_ID) assigned to MY_ID (SRC_ID) AND SRC_TYPE_ID = 7 AND SEC_ATTR_ID = 2 AND FRR_ID =1; --BD_POP_FRR_XREF UPDATE BD_POP_FRR_XREF SET FRR_ID =2 WHERE MY_ID = :new.MY_ID AND FRR_ID =1; --MY_PROGRAM_XREF_V (BD_SRC_SEC) UPDATE BD_SRC_SEC SET FRR_ID=2 WHERE SRC_ID = :new.MY_ID -- MY_ID (SRC_ID) AND SRC_TYPE_ID = 7 AND SEC_ATTR_ID = 5 AND FRR_ID =1; --BD_PROGR_SUPPL_XREF UPDATE BD_TRACE_XREF SET FRR_ID=2 WHERE PUBL_ID =:new.MY_ID AND FRR_ID =1; end if; :new.last_updated_by := NVL(v('APP_USER'), USER); :new.last_updated_on := SYSDATE; END;
Add your voice to the tech community where 5M+ people just like you are talking about what matters.
Join the community of 500,000 technology professionals and ask your questions.