Index: openacs.org-dev/packages/acs-tcl/tcl/site-nodes-procs-oracle.xql =================================================================== RCS file: /usr/local/cvsroot/openacs.org-dev/packages/acs-tcl/tcl/site-nodes-procs-oracle.xql,v diff -u -r1.1.1.1 -r1.1.1.2 --- openacs.org-dev/packages/acs-tcl/tcl/site-nodes-procs-oracle.xql 9 Jul 2002 17:34:59 -0000 1.1.1.1 +++ openacs.org-dev/packages/acs-tcl/tcl/site-nodes-procs-oracle.xql 8 Oct 2002 15:46:50 -0000 1.1.1.2 @@ -21,7 +21,8 @@ from acs_objects where acs_objects.object_id = site_nodes.object_id) as object_type, apm_packages.package_key, - apm_packages.package_id + apm_packages.package_id, + apm_packages.instance_name from site_nodes, apm_packages where site_nodes.object_id = apm_packages.package_id(+) @@ -40,7 +41,8 @@ from acs_objects where acs_objects.object_id = site_nodes.object_id) as object_type, apm_packages.package_key, - apm_packages.package_id + apm_packages.package_id, + apm_packages.instance_name from site_nodes, apm_packages where site_nodes.node_id = :node_id