create or replace trigger
RA_FILES_TRIGGER
-- Action,Column and Table name
after
insert or delete on eba_intrack_files
for each row
-- Excutable PL/SQL Section
begin
-- For Inserting (New Files)
if inserting then
begin
insert into eba_intrack_recent_activities(Ticket_Number,Summary,created)
values ((select ticket_number from eba_intrack_incidents where id = :new.INCIDENT_ID),
to_char('<b>'||:new.CREATED_BY||'</b>'||' uploaded a attachment file '),
:new.CREATED);
end;
-- For Deleting (Deleted Files)
elsif deleting then
begin
insert into eba_intrack_recent_activities(Ticket_Number,Summary,created)
values ((select ticket_number from eba_intrack_incidents where id = :new.INCIDENT_ID),
to_char('<b>'||:new.UPDATED_BY||'</b>'||' deleted a attachment file '),
:new.UPDATED);
end;
end if;
end;
/
error:
