oracle8.1.6 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 where bounce_count >= :max_bounce_count) 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' and n.notification_time < sysdate - :notification_interval and n.notification_count < :max_notification_count update acs_mail_lite_bounce_notif set notification_time = trunc(sysdate), notification_count = notification_count + 1 where user_id = :user_id delete from acs_mail_lite_bounce where user_id in (select user_id from acs_mail_lite_mail_log where last_mail_date < sysdate - :max_days_to_bounce) insert into acs_mail_lite_queue (message_id, to_addr, from_addr, subject, body, extra_headers, bcc, package_id, valid_email_p) values (acs_mail_lite_id_seq.nextval, :to_addr, :from_addr, :subject, :body, :eh_list, :bcc, :package_id, decode(:valid_email_p,'1','t','f')) update acs_mail_lite_mail_log set last_mail_date = sysdate where user_id = :user_id insert into acs_mail_lite_mail_log (user_id, last_mail_date) values (:user_id, sysdate) select message_id, to_addr, from_addr, subject, body, extra_headers, bcc, package_id, decode(valid_email_p,'t',1,0) as valid_email_p from acs_mail_lite_queue insert into acs_mail_lite_queue (message_id, to_addr, from_addr, subject, body, extra_headers, bcc, package_id, valid_email_p) values (acs_mail_lite_id_seq.nextval, :to_addr, :from_addr, :subject, :body, :extraheaders, :bcc, :package_id, decode(:valid_email_p,'1','t','f'))