ORCLE触发器表1新增数据,数据按条件增加到表2

表uapbp_project中新增一行数据后,如果pk_proclass=1,则把表中的code和name新增到表bd_defdoc中,pk_defdoclist=1,反之表1的pk_proclass=2,就放到表2,pk_defdoclist=2中

create or replace trigger uapbp_project_trigger
    after insert
    on uapbp_project
    for each row
begin
    case
        when :new.pk_proclass = 1 then
            insert into bd_defdoc(code, name) values (:new.code,:new.name);
        when :new.pk_proclass = 2 then
            insert into2(code, name) values (:new.code,:new.name);
    end case;
end;