oracle8.1.6
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 party_id = :user_id
insert into acs_mail_lite_mail_log (party_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'))