2,596
社区成员
发帖
与我相关
我的任务
分享
create or replace trigger tr_2205_id
before insert or update on pb_pay_request
REFERENCING NEW AS NEW OLD AS OLD
for each row
DECLARE
begin
if (:new.vt_code='2203') then
:new.hold9:=:new.pay_voucher_id;
elsif (:new.vt_code='5201') then
:new.hold9:=:new.str_pay_request_id;
end if;
end;