Index: openacs-4/packages/categories/sql/oracle/category-link-package.sql
===================================================================
RCS file: /usr/local/cvsroot/openacs-4/packages/categories/sql/oracle/category-link-package.sql,v
diff -u -r1.1 -r1.2
--- openacs-4/packages/categories/sql/oracle/category-link-package.sql	8 Feb 2004 17:30:45 -0000	1.1
+++ openacs-4/packages/categories/sql/oracle/category-link-package.sql	6 Dec 2004 12:05:28 -0000	1.2
@@ -28,7 +28,7 @@
     IS
         v_link_id	integer; 
     BEGIN
-	select category_links_id_seq.nextval() into v_link_id from dual;
+	select category_links_id_seq.nextval into v_link_id from dual;
 
 	insert into category_links (link_id, from_category_id, to_category_id)
 	values (v_link_id, new.from_category_id, new.to_category_id);
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 -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);