Index: openacs-4/packages/acs-kernel/sql/oracle/apm-create.sql =================================================================== RCS file: /usr/local/cvsroot/openacs-4/packages/acs-kernel/sql/oracle/apm-create.sql,v diff -u -r1.50 -r1.51 --- openacs-4/packages/acs-kernel/sql/oracle/apm-create.sql 23 Mar 2010 21:53:49 -0000 1.50 +++ openacs-4/packages/acs-kernel/sql/oracle/apm-create.sql 25 Mar 2010 17:33:52 -0000 1.51 @@ -968,8 +968,6 @@ default null, package_key in apm_parameters.package_key%TYPE, parameter_name in apm_parameters.parameter_name%TYPE, - scope in apm_parameters.scope%TYPE - default 'instance', description in apm_parameters.description%TYPE default null, scope in apm_parameters.scope%TYPE @@ -1588,11 +1586,15 @@ for pkg in (select package_id from apm_packages where package_key = register_parameter.package_key) loop v_value_id := apm_parameter_value.new( - package_id => pkg.package_id, - parameter_id => v_parameter_id, - attr_value => register_parameter.default_value - ); + package_id => pkg.package_id, + parameter_id => v_parameter_id, + attr_value => register_parameter.default_value); end loop; + else + v_value_id := apm_parameter_value.new( + package_id => null, + parameter_id => v_parameter_id, + attr_value => register_parameter.default_value); end if; return v_parameter_id; Index: openacs-4/packages/acs-kernel/sql/oracle/upgrade/upgrade-5.6.0d6-5.6.0d7.sql =================================================================== RCS file: /usr/local/cvsroot/openacs-4/packages/acs-kernel/sql/oracle/upgrade/upgrade-5.6.0d6-5.6.0d7.sql,v diff -u -r1.3 -r1.4 --- openacs-4/packages/acs-kernel/sql/oracle/upgrade/upgrade-5.6.0d6-5.6.0d7.sql 23 Mar 2010 21:53:49 -0000 1.3 +++ openacs-4/packages/acs-kernel/sql/oracle/upgrade/upgrade-5.6.0d6-5.6.0d7.sql 25 Mar 2010 17:33:52 -0000 1.4 @@ -114,8 +114,6 @@ default null, package_key in apm_parameters.package_key%TYPE, parameter_name in apm_parameters.parameter_name%TYPE, - scope in apm_parameters.scope%TYPE - default 'instance', description in apm_parameters.description%TYPE default null, scope in apm_parameters.scope%TYPE @@ -445,6 +443,11 @@ attr_value => register_parameter.default_value ); end loop; + else + v_value_id := apm_parameter_value.new( + package_id => null, + parameter_id => v_parameter_id, + attr_value => register_parameter.default_value); end if; return v_parameter_id;