Index: openacs-4/packages/acs-tcl/tcl/apm-procs-oracle.xql
===================================================================
RCS file: /usr/local/cvsroot/openacs-4/packages/acs-tcl/tcl/apm-procs-oracle.xql,v
diff -u -r1.12 -r1.13
--- openacs-4/packages/acs-tcl/tcl/apm-procs-oracle.xql	1 Apr 2004 20:56:29 -0000	1.12
+++ openacs-4/packages/acs-tcl/tcl/apm-procs-oracle.xql	16 Jun 2004 01:34:24 -0000	1.13
@@ -65,7 +65,7 @@
 <fullquery name="apm_parameter_register.apm_parameter_cache_update">      
       <querytext>
       
-	select v.package_id, p.parameter_name,
+	select nvl(v.package_id, 0) as 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