创建触发器

CREATE OR REPLACE TRIGGER "BIUD_T_ZZG01" 
  BEFORE INSERT ON T_ZZG01
  REFERENCING NEW AS N
  FOR EACH ROW
DECLARE
  STEMP VARCHAR2(30);
BEGIN
  SELECT PKG_ORDER.GETORDERNO(:N.BDGAGENCY,
                              :N.FUNDTYPE,
                              :N.INCOMEEXPMANAGE,
                              :N.PAYTYPE,
                              :N.EXPFUNC,
                              :N.PROGRAM,
                              :N.ELEMENT10)
    INTO STEMP
    FROM DUAL;
  :N.ORDERNO := STEMP;
END;