光是模仿不行,必须要自己去做; --添加部门时自动创建编号 CREATE OR REPLACE TRIGGER TRG_ADDDEPART BEFORE INSERT ON T_DEPARTMENTINFO FOR EACH ROW DECLARE V_B BOOLEAN; BEGIN SELECT SEQ_DEPART.NEXTVAL INTO :NEW.SN FROM DUAL; V_B := F_LOGINFO('部门编码为:'||:NEW.SN,'部门名称:'||:NEW.DEPARTNAME,'添加新部门!'); END TRG_ADDDEPART; --创建日志的存储CREATE OR REPLACE PROCEDURE P_LOGINFO( P_S01 IN VARCHAR2, P_S02 IN VARCHAR2, P_S03 IN VARCHAR2) IS
BEGIN BEGIN INSERT INTO T_LOGINFO (SN,S_01,S_02,S_03,D_01) VALUES (1,P_S01,P_S02,P_S03,TO_CHAR(SYSDATE,'YYYYMMDDHH24MISS')); COMMIT; EXCEPTION WHEN OTHERS THEN INSERT INTO T_LOGINFO (SN,S_01,S_02,S_03,D_01) VALUES(1,P_S01,'向日志表中插入信息时出错!','错误!',TO_CHAR(SYSDATE,'YYYYMMDDHH24MISS') ); COMMIT; END; END P_LOGINFO;
--添加部门时自动创建编号
CREATE OR REPLACE TRIGGER TRG_ADDDEPART
BEFORE INSERT ON T_DEPARTMENTINFO
FOR EACH ROW
DECLARE V_B BOOLEAN;
BEGIN
SELECT SEQ_DEPART.NEXTVAL INTO :NEW.SN FROM DUAL;
V_B := F_LOGINFO('部门编码为:'||:NEW.SN,'部门名称:'||:NEW.DEPARTNAME,'添加新部门!');
END TRG_ADDDEPART;
--创建日志的存储CREATE OR REPLACE PROCEDURE P_LOGINFO(
P_S01 IN VARCHAR2,
P_S02 IN VARCHAR2,
P_S03 IN VARCHAR2) IS
BEGIN
BEGIN
INSERT INTO T_LOGINFO (SN,S_01,S_02,S_03,D_01)
VALUES (1,P_S01,P_S02,P_S03,TO_CHAR(SYSDATE,'YYYYMMDDHH24MISS'));
COMMIT;
EXCEPTION
WHEN OTHERS THEN
INSERT INTO T_LOGINFO (SN,S_01,S_02,S_03,D_01)
VALUES(1,P_S01,'向日志表中插入信息时出错!','错误!',TO_CHAR(SYSDATE,'YYYYMMDDHH24MISS') );
COMMIT;
END;
END P_LOGINFO;