Index: openacs-4/packages/news/news.info
===================================================================
RCS file: /usr/local/cvsroot/openacs-4/packages/news/news.info,v
diff -u -N -r1.18.2.5 -r1.18.2.6
--- openacs-4/packages/news/news.info	26 Sep 2005 11:29:23 -0000	1.18.2.5
+++ openacs-4/packages/news/news.info	3 Feb 2006 21:09:33 -0000	1.18.2.6
@@ -20,8 +20,8 @@
         <requires url="acs-kernel" version="5.2.0d2"/>
         <requires url="general-comments" version="4.6.1"/>
         <requires url="rss-support" version="0.3d5"/>
+        <requires url="notifications" version="5.2.0d1" />
 
-
         <callbacks>
             <callback type="after-install"  proc="news::install::after_install"/>
             <callback type="before-uninstall"  proc="news::sc::unregister_news_fts_impl"/>
Index: openacs-4/packages/news/tcl/news-callback-procs-oracle.xql
===================================================================
RCS file: /usr/local/cvsroot/openacs-4/packages/news/tcl/Attic/news-callback-procs-oracle.xql,v
diff -u -N
--- /dev/null	1 Jan 1970 00:00:00 -0000
+++ openacs-4/packages/news/tcl/news-callback-procs-oracle.xql	3 Feb 2006 21:09:33 -0000	1.1.2.1
@@ -0,0 +1,13 @@
+<?xml version="1.0"?>
+
+<queryset>
+    <rdbms><type>oracle</type><version>8.1.7</version></rdbms>
+
+    <fullquery name="callback::search::url::impl::news.select_news_package_url">
+        <querytext>
+            select site_node.url(min(node_id))
+            from site_nodes
+            where object_id = :package_id
+        </querytext>
+    </fullquery>
+</queryset>