Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.server -> triggers using sequence to compile
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;