Index: openacs-4/packages/categories/sql/oracle/category-synonym-package.sql =================================================================== RCS file: /usr/local/cvsroot/openacs-4/packages/categories/sql/oracle/category-synonym-package.sql,v diff -u -r1.2.2.1 -r1.2.2.2 --- openacs-4/packages/categories/sql/oracle/category-synonym-package.sql 8 Feb 2005 15:52:28 -0000 1.2.2.1 +++ openacs-4/packages/categories/sql/oracle/category-synonym-package.sql 8 Feb 2005 16:00:27 -0000 1.2.2.2 @@ -268,7 +268,7 @@ -- triggers for category synonyms ----- -create trigger ins_synonym_on_ins_transl_trg +create or replace trigger ins_synonym_on_ins_transl_trg after insert on category_translations for each row declare v_synonym_id integer;