触发器，新增一条数据将其中的俩个字段写到另一张表对应的字段

CREATE OR REPLACE TRIGGER wastage_test
BEFORE INSERT ON ic_wastage_b 
for each row
declare 
PRAGMA AUTONOMOUS_TRANSACTION;
	begin
	UPDATE dm_delivbill_b SET
      nsignastnum=:new.noutsignastnum,nsignnum=:new.noutsignnum where cfirstbid=:new.cfirstbillbid;
		commit;				
END wastage_test;