using utl_mail
Login to rate this answer.
KARI
Answered On : Oct 29th, 2011
UTL_MAIL:
type procedure in UTL_MAIL
1)SEND (send the message without attachment)
Code
UTL_MAIL.SEND(sender =>'karimuth@amazon.com',recipients=>'karimuthu.bala@gmail.com',message =>'HAPPY BIRTHDAY',subject => 'birthday wishes');
2)SEND_ATTACH_RAW
(FOR message
WITH binary attachment
)
Code
UTL_MAIL.SEND_ATTACH_RAW(sender =>'karimuth@amazon.com',recipients=>'karimuthu.bala@gmail.com',message =>'HAPPY BIRTHDAY',subject => 'birthday wishes'
mime_type => 'text/html',attachment => get_image('oracle.gif'),att_inline =>true,att_min_type =>'image/gif',att_filename =>'oracle.gif');
3)SEND_ATTACH_VARCHAR2(for messages with text attachment)
Code
UTL_MAIL.SEND_ATTACH_VARCHAR2(sender =>'karimuth@amazon.com',recipients=>'karimuthu.bala@gmail.com',message =>'HAPPY BIRTHDAY',subject => 'birthday wishes'
mime_type => 'text/html',attachment => get_file('test.txt'),att_inline =>flase,att_min_type =>'text/plain',att_filename =>'test.txt');
Login to rate this answer.