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 -N -r1.18 -r1.19
--- openacs-4/packages/notifications/tcl/sweep-procs-oracle.xql	7 Jun 2008 20:29:01 -0000	1.18
+++ openacs-4/packages/notifications/tcl/sweep-procs-oracle.xql	2 Sep 2008 22:32:00 -0000	1.19
@@ -45,7 +45,7 @@
             where nnr.notification_id = notification_user_map.notification_id(+)
               and nnr.user_id = notification_user_map.user_id(+)
               and notification_user_map.sent_date is null
-              and nnr.notif_date < sysdate
+              and (nnr.notif_date is null or nnr.notif_date < sysdate)
               and acs_objects.object_id = nnr.request_id
               and acs_objects.creation_date <= nnr.notif_date
             order by nnr.user_id, nnr.type_id, nnr.notif_date