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 -N -r1.2 -r1.3
--- openacs-4/packages/categories/sql/oracle/category-synonym-package.sql	19 Feb 2004 19:11:17 -0000	1.2
+++ openacs-4/packages/categories/sql/oracle/category-synonym-package.sql	6 Dec 2004 12:05:28 -0000	1.3
@@ -62,7 +62,7 @@
     BEGIN
 	-- get new synonym_id
 	if (new.synonym_id is null) then
-		select category_synonyms_id_seq.nextval() into v_synonym_id from dual;
+		select category_synonyms_id_seq.nextval into v_synonym_id from dual;
 	else 
 		v_synonym_id := new.synonym_id;
 	end if;
@@ -141,7 +141,7 @@
 	end if;
 
 	-- get new search query id
-	select category_search_id_seq.nextval() into v_query_id from dual;
+	select category_search_id_seq.nextval into v_query_id from dual;
 
 	-- convert string to uppercase and substitute special chars
 	v_search_text := category_synonym.convert_string (search.search_text);