Index: openacs.org-dev/packages/acs-tcl/tcl/apm-procs-oracle.xql
===================================================================
RCS file: /usr/local/cvsroot/openacs.org-dev/packages/acs-tcl/tcl/apm-procs-oracle.xql,v
diff -u -r1.1.1.1 -r1.1.1.2
--- openacs.org-dev/packages/acs-tcl/tcl/apm-procs-oracle.xql	9 Jul 2002 17:34:59 -0000	1.1.1.1
+++ openacs.org-dev/packages/acs-tcl/tcl/apm-procs-oracle.xql	31 Jul 2002 16:30:56 -0000	1.1.1.2
@@ -53,7 +53,8 @@
 <fullquery name="apm_parameter_register.apm_parameter_cache_update">      
       <querytext>
       
-	select v.package_id, p.parameter_name, nvl(p.default_value, v.attr_value) as attr_value
+	select v.package_id, p.parameter_name,
+          decode(v.value_id, null, p.default_value, v.attr_value) as attr_value
 	from apm_parameters p, apm_parameter_values v
 	where p.package_key = :package_key
 	and p.parameter_id = v.parameter_id (+)