Index: openacs-4/packages/forums/tcl/messages-procs-oracle.xql
===================================================================
RCS file: /usr/local/cvsroot/openacs-4/packages/forums/tcl/Attic/messages-procs-oracle.xql,v
diff -u -r1.3 -r1.4
--- openacs-4/packages/forums/tcl/messages-procs-oracle.xql	3 Jun 2002 04:39:05 -0000	1.3
+++ openacs-4/packages/forums/tcl/messages-procs-oracle.xql	3 Jun 2002 05:53:55 -0000	1.4
@@ -27,6 +27,16 @@
         </querytext>
     </fullquery>
 
+    <fullquery name="forum::message::do_notifications.select_forums_package_url">
+        <querytext>
+            select site_node.url(node_id)
+            from site_nodes
+            where object_id = (select package_id
+                               from forums_forums
+                               where forums_forums.forum_id = :forum_id)
+        </querytext>
+    </fullquery>
+
     <fullquery name="forum::message::delete.delete_message">
         <querytext>
             declare begin