Index: openacs-4/packages/acs-mail-lite/tcl/acs-mail-lite-procs-oracle.xql
===================================================================
RCS file: /usr/local/cvsroot/openacs-4/packages/acs-mail-lite/tcl/acs-mail-lite-procs-oracle.xql,v
diff -u -r1.3 -r1.4
--- openacs-4/packages/acs-mail-lite/tcl/acs-mail-lite-procs-oracle.xql	14 Jan 2004 17:34:52 -0000	1.3
+++ openacs-4/packages/acs-mail-lite/tcl/acs-mail-lite-procs-oracle.xql	20 Apr 2004 21:12:50 -0000	1.4
@@ -6,7 +6,8 @@
    <fullquery name="acs_mail_lite::check_bounces.send_notification_to_bouncing_email">
      <querytext>
 
-       insert into acs_mail_lite_bounce_notif
+       insert into acs_mail_lite_bounce_notif 
+       (user_id, notification_count, notification_time)
        (select user_id, 0 as notification_count,
                trunc(sysdate-1-:notification_interval) as notification_time
         from acs_mail_lite_bounce
@@ -18,7 +19,7 @@
    <fullquery name="acs_mail_lite::check_bounces.get_recent_bouncing_users">
      <querytext>
 
-       select u.user_id, u.email, u.first_names || ' ' u.last_name as name
+       select u.user_id, u.email, u.first_names || ' ' || u.last_name as name
        from cc_users u, acs_mail_lite_bounce_notif n
        where u.user_id = n.user_id
        and u.email_bouncing_p = 't'