Index: openacs-4/packages/acs-content-repository/sql/oracle/upgrade/upgrade-5.2.0a1-5.2.0a2.sql
===================================================================
RCS file: /usr/local/cvsroot/openacs-4/packages/acs-content-repository/sql/oracle/upgrade/upgrade-5.2.0a1-5.2.0a2.sql,v
diff -u -r1.1.2.7 -r1.1.2.8
--- openacs-4/packages/acs-content-repository/sql/oracle/upgrade/upgrade-5.2.0a1-5.2.0a2.sql	27 Oct 2005 19:30:50 -0000	1.1.2.7
+++ openacs-4/packages/acs-content-repository/sql/oracle/upgrade/upgrade-5.2.0a1-5.2.0a2.sql	27 Oct 2005 23:26:51 -0000	1.1.2.8
@@ -1953,11 +1953,7 @@
   for type_rec in (select object_type,table_name from acs_object_types
     connect by supertype = prior object_type 
     start with object_type = 'content_revision') loop
-        select decode(count(*),0,'f','t') into v_exists_p
-         from user_tables
-         where table_name = upper(type_rec.table_name);
-
-        if v_exists_p = 't' then
+        if table_exists(type_rec.table_name) then
             content_type.refresh_view(type_rec.object_type);
             content_type.refresh_trigger(type_rec.object_type);
              content_type.refresh_view(type_rec.object_type);
@@ -1966,3 +1962,4 @@
 
 end;
 /
+show errors;