zahar

 Profile Answers by zahar 

• Jun 7th, 2011

 

using utl_mail

KARI

• Oct 29th, 2011

 

UTL_MAIL:

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

Code
span style="color: #F00;">'karimuth@amazon.com',recipients=>'karimuthu.bala@gmail.com',message =>'HAPPY BIRTHDAY',subject => 'birthday wishes'

Code
span style="color: #F00;">'karimuth@amazon.com',recipients=>'karimuthu.bala@gmail.com',message =>'HAPPY BIRTHDAY',subject => 'birthday wishes''text/html''oracle.gif''image/gif''oracle.gif'

3)SEND_ATTACH_VARCHAR2(for messages with text attachment)

Code
span style="color: #F00;">'karimuth@amazon.com',recipients=>'karimuthu.bala@gmail.com',message =>'HAPPY BIRTHDAY',subject => 'birthday wishes''text/html''test.txt''text/plain''test.txt'