Create Or Replace Trigger Insert_TOS_D_PATIENT_PAST
before Insert On TOS_D_PATIENT_PAST For Each Row
Begin
DECLARE RNT INT := 0;
BEGIN
SELECT COUNT(1) INTO rnt from tos_d_patient_info_summary t where t.patient_id = :new.patient_id;
if(rnt>0) then
update tos_d_patient_info_summary t
set
t.knj_kiorrk = TOS_SP_PATIENTINFOMNGDATA.FILL_KNJKIORRK(:new.patient_id) where t.patient_id = :new.patient_id;
else
Insert Into tos_d_patient_info_summary(patient_id,knj_kiorrk) Values(:new.patient_id,TOS_SP_PATIENTINFOMNGDATA.FILL_KNJKIORRK(:new.patient_id));
end if;
END;
End;
我像做一个update功能,代码逻辑都一样,,把上面的insert改成update后,,更新表的时候报错!!请问代码应该怎么改啊
before Insert On TOS_D_PATIENT_PAST For Each Row
Begin
DECLARE RNT INT := 0;
BEGIN
SELECT COUNT(1) INTO rnt from tos_d_patient_info_summary t where t.patient_id = :new.patient_id;
if(rnt>0) then
update tos_d_patient_info_summary t
set
t.knj_kiorrk = TOS_SP_PATIENTINFOMNGDATA.FILL_KNJKIORRK(:new.patient_id) where t.patient_id = :new.patient_id;
else
Insert Into tos_d_patient_info_summary(patient_id,knj_kiorrk) Values(:new.patient_id,TOS_SP_PATIENTINFOMNGDATA.FILL_KNJKIORRK(:new.patient_id));
end if;
END;
End;
我像做一个update功能,代码逻辑都一样,,把上面的insert改成update后,,更新表的时候报错!!请问代码应该怎么改啊
SELECT COUNT(1) INTO rnt from tos_d_patient_info_summary t where t.patient_id = :new.patient_id;