CREATE OR REPLACE TRIGGER T_SM_OUTPROJECT BEFORE INSERT on DTSCXT.Sm_Construct_Project
FOR EACH ROW
DECLARE
INTEGRITY_ERROR EXCEPTION;
ERRNO INTEGER;
ERRMSG CHAR(200);
--可根据具体情况更改数据类型。
MAX_VALUE NUMBER;
BEGIN
--主键名需动态更改。
SELECT MAX(CPROJECT_ID) + 1 INTO MAX_VALUE FROM Sm_Construct_Project;
IF MAX_VALUE IS NULL THEN
MAX_VALUE := 1;
END IF;
--主键名需动态更改。
SELECT MAX_VALUE INTO :NEW.CPROJECT_ID FROM DUAL;
-- ERRORS HANDLING
EXCEPTION
WHEN INTEGRITY_ERROR THEN
RAISE_APPLICATION_ERROR(ERRNO, ERRMSG);
END;