Function/procedureReturn TypeDescriptionSEND[sender, recipients, cc, bcc, subject, message [, mime_type [, priority ]]]
n/aPaket dan mengirim email ke server SMTP. SEND_ATTACH_RAW[sender, recipients, cc, bcc, subject, message, mime_type, priority, attachment [, att_inline [, att_mime_type [, att_filename ]]]]
_n/aSama seperti prosedur SEND
tetapi dengan BYTEA
atau lampiran objek besar.
DECLARE v_sender VARCHAR2[30]; v_recipients VARCHAR2[60]; v_subj VARCHAR2[20]; v_msg VARCHAR2[200]; BEGIN v_sender := 'jsmith@enterprisedb.com'; v_recipients := 'ajones@enterprisedb.com,rrogers@enterprisedb.com'; v_subj := 'Holiday Party'; v_msg := 'This year''s party is scheduled for Friday, Dec. 21 at ' || '6:00 PM. Please RSVP by Dec. 15th.'; UTL_MAIL.SEND[v_sender,v_recipients,NULL,NULL,v_subj,v_msg]; END;0n/Sama seperti prosedur
SEND
tetapi dengan lampiran DECLARE v_sender VARCHAR2[30]; v_recipients VARCHAR2[60]; v_subj VARCHAR2[20]; v_msg VARCHAR2[200]; BEGIN v_sender := 'jsmith@enterprisedb.com'; v_recipients := 'ajones@enterprisedb.com,rrogers@enterprisedb.com'; v_subj := 'Holiday Party'; v_msg := 'This year''s party is scheduled for Friday, Dec. 21 at ' || '6:00 PM. Please RSVP by Dec. 15th.'; UTL_MAIL.SEND[v_sender,v_recipients,NULL,NULL,v_subj,v_msg]; END;2
Seorang administrator harus memberikan hak eksekusi kepada setiap pengguna atau grup sebelum mereka dapat menggunakan paket ini
MENGIRIM
Prosedur SEND
_ mengirim email ke server SMTP
SEND[ VARCHAR2, VARCHAR2, VARCHAR2, VARCHAR2, VARCHAR2, VARCHAR2 [, VARCHAR2 [, PLS_INTEGER ]]]
Parameter
DECLARE v_sender VARCHAR2[30]; v_recipients VARCHAR2[60]; v_subj VARCHAR2[20]; v_msg VARCHAR2[200]; BEGIN v_sender := 'jsmith@enterprisedb.com'; v_recipients := 'ajones@enterprisedb.com,rrogers@enterprisedb.com'; v_subj := 'Holiday Party'; v_msg := 'This year''s party is scheduled for Friday, Dec. 21 at ' || '6:00 PM. Please RSVP by Dec. 15th.'; UTL_MAIL.SEND[v_sender,v_recipients,NULL,NULL,v_subj,v_msg]; END;_4
Alamat email pengirim
DECLARE v_sender VARCHAR2[30]; v_recipients VARCHAR2[60]; v_subj VARCHAR2[20]; v_msg VARCHAR2[200]; BEGIN v_sender := 'jsmith@enterprisedb.com'; v_recipients := 'ajones@enterprisedb.com,rrogers@enterprisedb.com'; v_subj := 'Holiday Party'; v_msg := 'This year''s party is scheduled for Friday, Dec. 21 at ' || '6:00 PM. Please RSVP by Dec. 15th.'; UTL_MAIL.SEND[v_sender,v_recipients,NULL,NULL,v_subj,v_msg]; END;5
Alamat email penerima yang dipisahkan koma
DECLARE v_sender VARCHAR2[30]; v_recipients VARCHAR2[60]; v_subj VARCHAR2[20]; v_msg VARCHAR2[200]; BEGIN v_sender := 'jsmith@enterprisedb.com'; v_recipients := 'ajones@enterprisedb.com,rrogers@enterprisedb.com'; v_subj := 'Holiday Party'; v_msg := 'This year''s party is scheduled for Friday, Dec. 21 at ' || '6:00 PM. Please RSVP by Dec. 15th.'; UTL_MAIL.SEND[v_sender,v_recipients,NULL,NULL,v_subj,v_msg]; END;_6
Alamat email penerima salinan yang dipisahkan koma
DECLARE v_sender VARCHAR2[30]; v_recipients VARCHAR2[60]; v_subj VARCHAR2[20]; v_msg VARCHAR2[200]; BEGIN v_sender := 'jsmith@enterprisedb.com'; v_recipients := 'ajones@enterprisedb.com,rrogers@enterprisedb.com'; v_subj := 'Holiday Party'; v_msg := 'This year''s party is scheduled for Friday, Dec. 21 at ' || '6:00 PM. Please RSVP by Dec. 15th.'; UTL_MAIL.SEND[v_sender,v_recipients,NULL,NULL,v_subj,v_msg]; END;_7
Alamat email penerima salinan buta yang dipisahkan koma
DECLARE v_sender VARCHAR2[30]; v_recipients VARCHAR2[60]; v_subj VARCHAR2[20]; v_msg VARCHAR2[200]; BEGIN v_sender := 'jsmith@enterprisedb.com'; v_recipients := 'ajones@enterprisedb.com,rrogers@enterprisedb.com'; v_subj := 'Holiday Party'; v_msg := 'This year''s party is scheduled for Friday, Dec. 21 at ' || '6:00 PM. Please RSVP by Dec. 15th.'; UTL_MAIL.SEND[v_sender,v_recipients,NULL,NULL,v_subj,v_msg]; END;_8
Baris subjek email
DECLARE v_sender VARCHAR2[30]; v_recipients VARCHAR2[60]; v_subj VARCHAR2[20]; v_msg VARCHAR2[200]; BEGIN v_sender := 'jsmith@enterprisedb.com'; v_recipients := 'ajones@enterprisedb.com,rrogers@enterprisedb.com'; v_subj := 'Holiday Party'; v_msg := 'This year''s party is scheduled for Friday, Dec. 21 at ' || '6:00 PM. Please RSVP by Dec. 15th.'; UTL_MAIL.SEND[v_sender,v_recipients,NULL,NULL,v_subj,v_msg]; END;_9
Isi email
SEND_ATTACH_RAW[ VARCHAR2, VARCHAR2, VARCHAR2, VARCHAR2, VARCHAR2, VARCHAR2, VARCHAR2, PLS_INTEGER, BYTEA[, BOOLEAN [, VARCHAR2[, VARCHAR2 ]]]]_0
Jenis mime pesan. Standarnya adalah
SEND_ATTACH_RAW[ VARCHAR2, VARCHAR2, VARCHAR2, VARCHAR2, VARCHAR2, VARCHAR2, VARCHAR2, PLS_INTEGER, BYTEA[, BOOLEAN [, VARCHAR2[, VARCHAR2 ]]]]_1
SEND_ATTACH_RAW[ VARCHAR2, VARCHAR2, VARCHAR2, VARCHAR2, VARCHAR2, VARCHAR2, VARCHAR2, PLS_INTEGER, BYTEA[, BOOLEAN [, VARCHAR2[, VARCHAR2 ]]]]_2
Prioritas email Standarnya adalah
SEND_ATTACH_RAW[ VARCHAR2, VARCHAR2, VARCHAR2, VARCHAR2, VARCHAR2, VARCHAR2, VARCHAR2, PLS_INTEGER, BYTEA[, BOOLEAN [, VARCHAR2[, VARCHAR2 ]]]]3
Contoh
Blok anonim berikut mengirimkan pesan email sederhana
DECLARE v_sender VARCHAR2[30]; v_recipients VARCHAR2[60]; v_subj VARCHAR2[20]; v_msg VARCHAR2[200]; BEGIN v_sender := 'jsmith@enterprisedb.com'; v_recipients := 'ajones@enterprisedb.com,rrogers@enterprisedb.com'; v_subj := 'Holiday Party'; v_msg := 'This year''s party is scheduled for Friday, Dec. 21 at ' || '6:00 PM. Please RSVP by Dec. 15th.'; UTL_MAIL.SEND[v_sender,v_recipients,NULL,NULL,v_subj,v_msg]; END;
KIRIM_ATTACH_RAW
Prosedur
SEND_ATTACH_RAW[ VARCHAR2, VARCHAR2, VARCHAR2, VARCHAR2, VARCHAR2, VARCHAR2, VARCHAR2, PLS_INTEGER, BYTEA[, BOOLEAN [, VARCHAR2[, VARCHAR2 ]]]]4 mengirim email ke server SMTP dengan lampiran yang berisi data
BYTEA
atau objek besar [diidentifikasi oleh SEND_ATTACH_RAW[ VARCHAR2, VARCHAR2, VARCHAR2, VARCHAR2, VARCHAR2, VARCHAR2, VARCHAR2, PLS_INTEGER, BYTEA[, BOOLEAN [, VARCHAR2[, VARCHAR2 ]]]]6 objek besar]. Anda dapat menulis panggilan ke
SEND_ATTACH_RAW[ VARCHAR2, VARCHAR2, VARCHAR2, VARCHAR2, VARCHAR2, VARCHAR2, VARCHAR2, PLS_INTEGER, BYTEA[, BOOLEAN [, VARCHAR2[, VARCHAR2 ]]]]_4 dengan dua cara