Index: openacs-4/packages/news-aggregator-portlet/www/news-aggregator-portlet-oracle.xql
===================================================================
RCS file: /usr/local/cvsroot/openacs-4/packages/news-aggregator-portlet/www/news-aggregator-portlet-oracle.xql,v
diff -u -r1.3 -r1.3.2.1
--- openacs-4/packages/news-aggregator-portlet/www/news-aggregator-portlet-oracle.xql	14 Nov 2003 23:25:55 -0000	1.3
+++ openacs-4/packages/news-aggregator-portlet/www/news-aggregator-portlet-oracle.xql	17 Aug 2005 08:01:29 -0000	1.3.2.1
@@ -11,6 +11,9 @@
                s.title, 
                to_char(last_scanned, 'YYYY-MM-DD HH24:MI:SS') as last_scanned,
                to_char(creation_date, 'YYYY-MM-DD HH24') as sort_date,
+               (select site_node.url(site_nodes.node_id)
+               from site_nodes
+               where site_nodes.object_id = package_id) as url,
 	       feed_url, 
 	       item_id, 
                i.title as item_title,