Index: openacs-4/packages/notifications/tcl/sweep-procs-oracle.xql
===================================================================
RCS file: /usr/local/cvsroot/openacs-4/packages/notifications/tcl/sweep-procs-oracle.xql,v
diff -u -r1.1 -r1.2
--- openacs-4/packages/notifications/tcl/sweep-procs-oracle.xql	29 May 2002 05:12:01 -0000	1.1
+++ openacs-4/packages/notifications/tcl/sweep-procs-oracle.xql	3 Jun 2002 08:13:18 -0000	1.2
@@ -17,7 +17,7 @@
 
 <fullquery name="notification::sweep::sweep_notifications.select_notifications">
 <querytext>
-select notifications.notification_id, notif_subject, notif_text, notif_html, notification_requests.user_id
+select notifications.notification_id, notif_subject, notif_text, notif_html, notification_requests.user_id, acs_object.name(object_id) as object_name
 from notifications, notification_requests, notification_user_map
 where notifications.type_id = notification_requests.type_id
 and interval_id = :interval_id