I have view LIVE\_MATCHES (home,away,comp\_name) and 
table MATCHES (priority ,sport,sub\_list)

I need to create a trigger that inserts in TABLE from VIEW after the view is updated or inserted (doesn't matter) and to check that unique column (sub\_list) in table Matches isn't already inserted. Only need to insert from view is comp\_name, sport and priority are fixed variables.

```
 CREATE OR REPLACE TRIGGER LIVE_MATCHES_TO_MATCHES 
        instead of insert ON LIVE_MATCHES 
       for each row
              declare
       p_priority number:= 1;
       p_sport number:=0;
       begin
         insert into MATCHES (sub_list , priority , sport, created) 
         select :old.comp_name , p_priority, p_sport,sysdate
         from dual
          where not exists (      
         select 1 from MATCHES 
        where sub_list = :old.comp_name);
       end;

```

I edited trigger so it is compiled now without errors but it does not insert into table MATCHES. 

What am I doing wrong in this trigger.