Hey Guys,
I haven't ever had any luck getting a trigger to work so I thought I'd see if there were any trigger experts lurking around today. Here's what I need to do:
create or replace trigger del_pr_hst_tbl
before delete on SD_DTL_TBL
for each row
begin
delete from PR_HST_TBL where PR_HST_USER_ID = SD_DTL_USER_ID and
PR_HST_SRCH_NUM = SD_DTL_SRCH_NUM;
end;
I need to delete from PR_HST_TBL every time something is deleted from the SD_DTL_TBL. The two tables are linked by user_id and srch_num.
Any help would be greatly appreciated! Thanks!
Lisa
