Index: openacs-4/packages/acs-kernel/sql/oracle/upgrade/upgrade-5.3.2d1-5.3.2d2.sql
===================================================================
RCS file: /usr/local/cvsroot/openacs-4/packages/acs-kernel/sql/oracle/upgrade/upgrade-5.3.2d1-5.3.2d2.sql,v
diff -u -r1.1.2.1 -r1.1.2.2
--- openacs-4/packages/acs-kernel/sql/oracle/upgrade/upgrade-5.3.2d1-5.3.2d2.sql	24 May 2007 12:16:27 -0000	1.1.2.1
+++ openacs-4/packages/acs-kernel/sql/oracle/upgrade/upgrade-5.3.2d1-5.3.2d2.sql	6 Jun 2007 12:47:46 -0000	1.1.2.2
@@ -6,6 +6,18 @@
 -- @cvs-id $Id$
 --
 
-alter table apm_parameters drop constraint apm_parameter_datatype_ck;
-alter table apm_parameters add constraint apm_parameter_datatype_ck check(datat\
-ype in ('number', 'string','text'));
\ No newline at end of file
+declare v_result integer;
+begin
+select count(*) into v_result from user_constraints where constraint_name = 'apm_parameters_datatype_ck';
+if v_result > 0 then
+    execute immediate 'alter table apm_parameters drop constraint ''apm_parameters_datatype_ck''';
+end if;
+select count(*) into v_result from user_constraints where constraint_name = 'apm_parameter_datatype_ck';
+if v_result > 0 then
+execute immediate 'alter table apm_parameters drop constraint ''apm_parameter_datatype_ck''';
+end if;
+execute immediate 'alter table apm_parameters add constraint apm_parameters_datatype_ck check(datatype in (''number'', ''string'',''text''))';
+end;
+/
+show errors
+
