--触发器的失效的.
ORA-04098 trigger name is invalid and failed re-validationCause A trigger was attempted to be retrieved for execution and was found to be invalid. This also means that compilation/authorization failed for the trigger.
Action The options are to resolve the compilation/authorization errors, disable the trigger, or drop the trigger. For more information about enabling and disabling triggers, see the index entries on "enabling, triggers," "disabling, triggers," and "DROP TRIGGER command" in Oracle8 Server SQL Reference.
ORA-04098 trigger name is invalid and failed re-validationCause A trigger was attempted to be retrieved for execution and was found to be invalid. This also means that compilation/authorization failed for the trigger.
Action The options are to resolve the compilation/authorization errors, disable the trigger, or drop the trigger. For more information about enabling and disabling triggers, see the index entries on "enabling, triggers," "disabling, triggers," and "DROP TRIGGER command" in Oracle8 Server SQL Reference.
BEFORE
INSERT ON "BGMANAGER"."ALERT"
FOR EACH ROW
DECLARE
NUMS INTEGER;
BEGIN
select ZHANGID.NEXTVAL INTO NUMS FROM DUAL;
:NEW.BGMANAGER.REC_NO :=NUMS;
END;