WOW! Did you like this post? We'll send more interesting posts like UTL_SMTP API to send HTML Emails from PL/SQL to you!
Enter your Email Address:
  • Kiran Reddy

    Good article, helped me send mail from pl/sql.

  • Kranthi

    Very nice article Mr.shailender.

    I have one requirement here i want to send sql quries output to the mail body using SMTP.

    could please let me know how can i ?

    Thanks in advace.
    Kranthi.

    • Hi  Kranthi 🙂

      Thanks for reading my post. You can achieve your requirement by putting your sql query in a cursor, open the cursor and append the cursor data to email body variable (v_body).

      Thanks,
      Shailender

  • sriram

    very useful article, when i am triggering mails some are successful and others are triggering with out body…Please help me…