PL/SQL (MOSC)

MOSC Banner

After delete trigger

edited Dec 23, 2009 6:23PM in PL/SQL (MOSC) 6 commentsAnswered
 I need to write an after delete trigger. The purpose of that is after a row with certain order number in ttdsls040100 gets deleted, the trigger will fire and delete the row with the same order number in another table.

create or replace trigger TRITON.AFTER_INSERT_DELETE_tdsls040100
after insert or delete on TRITON.TTDSLS040100
for each row
begin
if INSERTING then
insert into event.tdsls040_change_tracking
(Primary_Key,
 Column_Name,
 Table_Name,
 Original_Value)
values
(:new.T$ORNO,
 'T$COMP',
 'TTDSLS040100',
 :new.T$COMP);
elsif DELETING then
delete from event.tdsls040_change_tracking
where Primary_Key =:old.T$ORNO;

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