oracle8.1.6 insert into acs_mail_lite_queue (message_id, creation_date, locking_server, to_addr, from_addr, reply_to, subject, package_id, file_ids, filesystem_files, delete_filesystem_files_p, mime_type, no_callback_p, use_sender_p, cc_addr, bcc_addr, body, extraheaders, object_id ) values (acs_mail_lite_id_seq.nextval, :creation_date, :locking_server, :to_addr, :from_addr, :reply_to, :subject, :package_id, :file_ids, :filesystem_files, decode(:delete_filesystem_files_p,'1','t','f'),, :mime_type, decode(:no_callback_p,'1','t','f'), decode(:use_sender_p,'1','t','f'), :cc_addr, :bcc_addr, :body, :extraheaders, :object_id ) 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 as id, creation_date, locking_server, to_addr, cc_addr, bcc_addr, from_addr, reply_to, subject, body, package_id, file_ids, filesystem_files, delete_filesystem_files_p, mime_type, decode(no_callback_p,'t',1,0) as no_callback_p, extraheaders, decode(use_sender_p,'t',1,0) as use_sender_p, object_id from acs_mail_lite_queue where locking_server = '' or locking_server is NULL