triggers using sequence to compile
From: yoann <ypoizeau_at_ifrance.com>
Date: 2 Apr 2003 02:01:47 -0800
Message-ID: <70be4d67.0304020201.8dd31d4_at_posting.google.com>
END IF;
END; MY SEQUENCE:
CREATE SEQUENCE COM_GROUP_AUTOINC INCREMENT BY 1 START WITH 2 MAXVALUE 1.0E28 MINVALUE 2 NOCYCLE CACHE 20 NOORDER; Someone can help me?
Thanks for all; Received on Wed Apr 02 2003 - 12:01:47 CEST
Date: 2 Apr 2003 02:01:47 -0800
Message-ID: <70be4d67.0304020201.8dd31d4_at_posting.google.com>
i have modify a table and some of my triggers have becomed invalid so
i have compiled THEM using the
DBMS_UTILITY.COMPILE_SCHEMA(schema_name); function
but know i have a problem. when i use sequence in a trigger, the
trigger doesn't work anymore
MY TRIGGER:
CREATE TRIGGER COM_GROUP_INC BEFORE INSERT
ON COM_GROUPS
FOR EACH ROW
DECLARE
next_number_of_group_id NUMBER;
BEGIN
IF :new.GROUP_ID=0 THEN
BEGIN
next_number_of_group_id := 0;
END;
ELSE
BEGIN
SELECT COM_GROUP_AUTOINC.NEXTVAL INTO next_number_of_group_id FROM dual; :new.GROUP_ID:=next_number_of_group_id;END;
END IF;
END; MY SEQUENCE:
CREATE SEQUENCE COM_GROUP_AUTOINC INCREMENT BY 1 START WITH 2 MAXVALUE 1.0E28 MINVALUE 2 NOCYCLE CACHE 20 NOORDER; Someone can help me?
Thanks for all; Received on Wed Apr 02 2003 - 12:01:47 CEST