Send e mail through PL SQL code (UTL_SMTP, UTL_MAIL)

utl_smtp example:

UTL_MAIL: This is the new package introduced in 10g. even though this uses the UTL_SMTP in the background the advantage with this script is we can change the mail server and ports in the configuration file with out changing the code.

3 Comments

  1. rutvi
    Jun 08, 2011 @ 12:13:26

    Hey…

    how to send email to multiple receipants?? rather than single 1.

    Thanks,

    Reply

  2. Manoj Kumar
    Apr 02, 2012 @ 15:20:03

    Hi,

    In the above to send mail for one receipants try to add more with ‘;’, seperated hope that works

    Thanks,
    Manoj

    Reply

  3. Debjit Sengupta
    Feb 24, 2013 @ 13:09:22

    Well written and it worked. Share more such stuffs and carry on with your good works.

    Reply

Leave a Reply