Index: openacs-4/packages/bulk-mail/tcl/bulk-mail-procs-oracle.xql
===================================================================
RCS file: /usr/local/cvsroot/openacs-4/packages/bulk-mail/tcl/bulk-mail-procs-oracle.xql,v
diff -u -r1.2 -r1.3
--- openacs-4/packages/bulk-mail/tcl/bulk-mail-procs-oracle.xql	16 Jan 2003 13:44:51 -0000	1.2
+++ openacs-4/packages/bulk-mail/tcl/bulk-mail-procs-oracle.xql	28 Aug 2003 09:41:53 -0000	1.3
@@ -22,8 +22,9 @@
         <querytext>
             select bulk_mail_messages.*
             from bulk_mail_messages
-            where bulk_mail_messages.sent_p = 'f'
+            where bulk_mail_messages.status = 'pending'
             and bulk_mail_messages.send_date <= sysdate
+            for update
         </querytext>
     </fullquery>