用包来实现 CREATE OR REPLACE PACKAGE pkg_test AS My_OPId varchar2(10); My_PURID varchar2(10); ..... END pkg_test; /create trigger name_tri before insert on table for each row begin pkg_test.My_OPId:=:new.My_OPId; pkg_test.My_PURID:=:new.My_PURID; ....... end; /
CREATE OR REPLACE PACKAGE pkg_test
AS
My_OPId varchar2(10);
My_PURID varchar2(10);
.....
END pkg_test;
/create trigger name_tri
before insert on table
for each row
begin
pkg_test.My_OPId:=:new.My_OPId;
pkg_test.My_PURID:=:new.My_PURID;
.......
end;
/