KARI

Oct 29th, 2011

UTL_MAIL:

type procedure in UTL_MAIL
1)SEND (send the message without attachment)

Code
BEGIN


UTL_MAIL.SEND(sender =>'karimuth@amazon.com',recipients=>'karimuthu.bala@gmail.com',message =>'HAPPY BIRTHDAY',subject => 'birthday wishes');


END


2)SEND_ATTACH_RAW(FOR message WITH binary attachment)

Code
BEGIN


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');


END

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');


END