Index: openacs-4/packages/acs-content-repository/sql/oracle/content-search.sql
===================================================================
RCS file: /usr/local/cvsroot/openacs-4/packages/acs-content-repository/sql/oracle/content-search.sql,v
diff -u -N -r1.1 -r1.2
--- openacs-4/packages/acs-content-repository/sql/oracle/content-search.sql	24 Mar 2001 22:00:48 -0000	1.1
+++ openacs-4/packages/acs-content-repository/sql/oracle/content-search.sql	19 Oct 2001 02:11:55 -0000	1.2
@@ -31,7 +31,9 @@
   indextype is ctxsys.context
   parameters ('FILTER content_filter_pref' );
 
-alter index cr_rev_content_index rebuild online parameters ('sync');
+-- DRB: Use the "online" version if you have Oracle Enterprise Edition
+-- alter index cr_rev_content_index rebuild online parameters ('sync');
+alter index cr_rev_content_index rebuild  parameters ('sync');
 
 ------------------------------------------------------------
 -- Set up an XML index for searching attributes
@@ -104,5 +106,7 @@
 /
 show errors
 
-alter index cr_rev_attribute_index rebuild online parameters ('sync');
+-- DRB: Use the "online" version if you have Oracle Enterprise Edition
+-- alter index cr_rev_attribute_index rebuild online parameters ('sync');
+alter index cr_rev_attribute_index rebuild parameters ('sync');
 
Index: openacs-4/packages/news/www/item.tcl
===================================================================
RCS file: /usr/local/cvsroot/openacs-4/packages/news/www/item.tcl,v
diff -u -N -r1.3 -r1.4
--- openacs-4/packages/news/www/item.tcl	16 Oct 2001 10:10:19 -0000	1.3
+++ openacs-4/packages/news/www/item.tcl	19 Oct 2001 02:11:55 -0000	1.4
@@ -68,7 +68,7 @@
 	set comment_link ""
         set comments ""
     }
-    
+
     set title $publish_title
     set context_bar [list $title]
 
Index: openacs-4/packages/search/sql/postgresql/search-sc-create.sql
===================================================================
RCS file: /usr/local/cvsroot/openacs-4/packages/search/sql/postgresql/search-sc-create.sql,v
diff -u -N -r1.3 -r1.4
--- openacs-4/packages/search/sql/postgresql/search-sc-create.sql	3 Oct 2001 04:04:41 -0000	1.3
+++ openacs-4/packages/search/sql/postgresql/search-sc-create.sql	19 Oct 2001 02:11:55 -0000	1.4
@@ -107,7 +107,6 @@
 );
 
 
-
 select acs_sc_msg_type__new (
            'FtsEngineDriver.Info.InputType',
 	   ''
@@ -127,8 +126,6 @@
 );
 
 
-
-
 --
 -- ACS-SC Contract: FtsContentProvider
 --
@@ -175,12 +172,3 @@
 	   'FtsContentProvider.Url.InputType',		-- operation_inputtype
 	   'FtsContentProvider.Url.OutputType'		-- operation_outputtype
 );
-
-
-
-
-
-
-
-
-
Index: openacs-4/packages/site-wide-search/sql/oracle/search-tables.sql
===================================================================
RCS file: /usr/local/cvsroot/openacs-4/packages/site-wide-search/sql/oracle/search-tables.sql,v
diff -u -N -r1.1 -r1.2
--- openacs-4/packages/site-wide-search/sql/oracle/search-tables.sql	20 Apr 2001 20:51:24 -0000	1.1
+++ openacs-4/packages/site-wide-search/sql/oracle/search-tables.sql	19 Oct 2001 02:11:55 -0000	1.2
@@ -477,7 +477,9 @@
 
 	-- construct dynamic sql to build index
 	v_cursor_id := dbms_sql.open_cursor;
-	v_code := 'alter index sws_srch_cts_ds_iidx rebuild online parameters (''sync'')';
+        -- DRB: use the "online" variant if you have Oracle Enterprise Edition
+	-- v_code := 'alter index sws_srch_cts_ds_iidx rebuild online parameters (''sync'')';
+	v_code := 'alter index sws_srch_cts_ds_iidx rebuild parameters (''sync'')';
 	dbms_sql.parse (v_cursor_id, v_code, dbms_sql.native);                     
 	v_result := dbms_sql.execute (v_cursor_id);
 	dbms_sql.close_cursor(v_cursor_id);
Index: openacs-4/packages/static-pages/static-pages.info
===================================================================
RCS file: /usr/local/cvsroot/openacs-4/packages/static-pages/static-pages.info,v
diff -u -N -r1.6 -r1.7
--- openacs-4/packages/static-pages/static-pages.info	13 Sep 2001 01:18:14 -0000	1.6
+++ openacs-4/packages/static-pages/static-pages.info	19 Oct 2001 02:11:55 -0000	1.7
@@ -34,7 +34,6 @@
             <file type="data_model" db_type="postgresql" path="sql/postgresql/static-pages-sws-drop.sql"/>
             <file type="data_model" db_type="postgresql" path="sql/postgresql/static-pages-sws.sql"/>
             <file type="package_spec" path="static-pages.info"/>
-            <file type="tcl_util" path="tcl/diff.tcl"/>
             <file type="query_file" db_type="oracle" path="tcl/static-pages-procs-oracle.xql"/>
             <file type="query_file" db_type="postgresql" path="tcl/static-pages-procs-postgresql.xql"/>
             <file type="tcl_procs" path="tcl/static-pages-procs.tcl"/>
Index: openacs-4/packages/static-pages/sql/postgresql/static-pages-create.sql
===================================================================
RCS file: /usr/local/cvsroot/openacs-4/packages/static-pages/sql/postgresql/static-pages-create.sql,v
diff -u -N -r1.7 -r1.8
--- openacs-4/packages/static-pages/sql/postgresql/static-pages-create.sql	4 Sep 2001 17:04:10 -0000	1.7
+++ openacs-4/packages/static-pages/sql/postgresql/static-pages-create.sql	19 Oct 2001 02:11:55 -0000	1.8
@@ -529,7 +529,7 @@
 
                         -- Copy permissions from the parent:
                         for v_permission_row in 
-                                select grantee_id,privilege from acs_permissions
+                                select * from acs_permissions
                                         where object_id = p_parent_id
                          loop
                                 perform acs_permission__grant_permission(
Index: openacs-4/packages/static-pages/tcl/static-pages-procs-postgresql.xql
===================================================================
RCS file: /usr/local/cvsroot/openacs-4/packages/static-pages/tcl/static-pages-procs-postgresql.xql,v
diff -u -N -r1.6 -r1.7
--- openacs-4/packages/static-pages/tcl/static-pages-procs-postgresql.xql	4 Sep 2001 17:04:10 -0000	1.6
+++ openacs-4/packages/static-pages/tcl/static-pages-procs-postgresql.xql	19 Oct 2001 02:11:55 -0000	1.7
@@ -16,7 +16,7 @@
 <fullquery name="sp_sync_cr_with_filesystem.get_folder_id">
       <querytext>
 
-        select coalesce(content_item__get_id(:cumulative_path,:root_folder_id),0)
+        select coalesce(content_item__get_id(:cumulative_path,:root_folder_id,'f'),0)
 
       </querytext>
 </fullquery>
@@ -25,10 +25,15 @@
 <fullquery name="sp_sync_cr_with_filesystem.create_new_folder">
       <querytext>
                 select static_page__new_folder (
+                        NULL,
                         :directory,             -- name
                         :directory,             -- label
+                        'Static pages folder',   -- description
                         :parent_folder_id,      -- parent_id
-                        'Static pages folder'   -- description
+                        current_timestamp,
+                        NULL,
+                        NULL,
+                        NULL
                 );
       </querytext>
 </fullquery>
Index: openacs-4/packages/webmail/sql/oracle/webmail-create.sql
===================================================================
RCS file: /usr/local/cvsroot/openacs-4/packages/webmail/sql/oracle/webmail-create.sql,v
diff -u -N -r1.1 -r1.2
--- openacs-4/packages/webmail/sql/oracle/webmail-create.sql	20 Apr 2001 20:51:23 -0000	1.1
+++ openacs-4/packages/webmail/sql/oracle/webmail-create.sql	19 Oct 2001 02:11:55 -0000	1.2
@@ -698,7 +698,9 @@
 create or replace procedure wm_resync_indexes
 as
 begin
-  execute immediate 'alter index wm_ctx_index rebuild online parameters(''sync'')';
+-- DRB: Use the "online" version if you have Oracle Enterprise Edition
+--  execute immediate 'alter index wm_ctx_index rebuild online parameters(''sync'')';
+  execute immediate 'alter index wm_ctx_index rebuild parameters(''sync'')';
 --  execute immediate 'alter index wm_att_ctx_index rebuild online parameters(''sync'')';
 end;
 /