Index: openacs-4/packages/acs-lang/sql/oracle/upgrade/upgrade-5.10.0d11-5.10.0d12.sql
===================================================================
RCS file: /usr/local/cvsroot/openacs-4/packages/acs-lang/sql/oracle/upgrade/Attic/upgrade-5.10.0d11-5.10.0d12.sql,v
diff -u -r1.1.2.1 -r1.1.2.2
--- openacs-4/packages/acs-lang/sql/oracle/upgrade/upgrade-5.10.0d11-5.10.0d12.sql	25 Aug 2020 13:38:12 -0000	1.1.2.1
+++ openacs-4/packages/acs-lang/sql/oracle/upgrade/upgrade-5.10.0d11-5.10.0d12.sql	12 Feb 2022 20:11:02 -0000	1.1.2.2
@@ -1,5 +1,19 @@
+-- Oracle version of 
+--    alter table add column ... if exists ... 
+--
+DECLARE
+  v_col_exists NUMBER;
+BEGIN
+  SELECT count(*) INTO v_col_exists
+    FROM user_tab_cols
+    WHERE column_name = 'OBJECT_ID'
+      AND table_name = 'LANG_MESSAGE_KEYS';
 
--- Untested!
-alter table lang_message_keys add column if not exists object_id integer
+   IF (v_col_exists = 0) THEN
+      EXECUTE IMMEDIATE 'alter table lang_message_keys add object_id integer
        constraint lang_message_keys_object_id_fk
-       references acs_objects(object_id) on delete cascade;
+       references acs_objects(object_id) on delete cascade';
+  END IF;
+END;
+/
+
