Index: openacs-4/packages/search/sql/oracle/search-packages-create.sql
===================================================================
RCS file: /usr/local/cvsroot/openacs-4/packages/search/sql/oracle/search-packages-create.sql,v
diff -u -r1.5.12.1 -r1.5.12.2
--- openacs-4/packages/search/sql/oracle/search-packages-create.sql	1 Mar 2021 18:20:47 -0000	1.5.12.1
+++ openacs-4/packages/search/sql/oracle/search-packages-create.sql	2 Mar 2021 08:08:44 -0000	1.5.12.2
@@ -57,7 +57,7 @@
 
     if p_event = 'DELETE' then
       select count(*) from acs_objects into l_count
-      where object_id = p_object_id);
+      where object_id = p_object_id;
       if l_count = 0 then
          return;
       end if;
Index: openacs-4/packages/search/sql/oracle/upgrade/upgrade-5.10.0d3-5.10.0d4.sql
===================================================================
RCS file: /usr/local/cvsroot/openacs-4/packages/search/sql/oracle/upgrade/upgrade-5.10.0d3-5.10.0d4.sql,v
diff -u -r1.1.2.1 -r1.1.2.2
--- openacs-4/packages/search/sql/oracle/upgrade/upgrade-5.10.0d3-5.10.0d4.sql	1 Mar 2021 18:20:47 -0000	1.1.2.1
+++ openacs-4/packages/search/sql/oracle/upgrade/upgrade-5.10.0d3-5.10.0d4.sql	2 Mar 2021 08:08:44 -0000	1.1.2.2
@@ -15,7 +15,7 @@
     if p_event = 'DELETE' then
 
       select count(*) from acs_objects into l_count
-      where object_id = p_object_id);
+      where object_id = p_object_id;
 
       if l_count = 0 then
          return;