https://bugzilla.wikimedia.org/show_bug.cgi?id=652





--- Comment #36 from minervino <[email protected]>  
2009-09-30 11:57:31 UTC ---
Thanks a lot. One detail. I forgot to kick out of the trigger's code the
"owner". Forgot it if you have already saw it.



CREATE OR REPLACE TRIGGER TRG_CATEGORY 
BEFORE INSERT ON CATEGORY
FOR EACH ROW 
   WHEN (NEW.CAT_ID IS NULL)
BEGIN
   SELECT CATEGORY_CAT_ID_VAL.NEXTVAL 
   INTO :NEW.CAT_ID 
   FROM DUAL; 
END;


-- 
Configure bugmail: https://bugzilla.wikimedia.org/userprefs.cgi?tab=email
------- You are receiving this mail because: -------
You are on the CC list for the bug.

_______________________________________________
Wikibugs-l mailing list
[email protected]
https://lists.wikimedia.org/mailman/listinfo/wikibugs-l

Reply via email to