2 Replies Latest reply: May 14, 2012 12:10 AM by 820876 RSS

    Sending a query result in a Oracle mail

    820876
      Hi all,

      I am using Oracle 10g/11g, and I am trying to send an auto generated email to the DBA about the failed jobs every day. I was able to send a mail with sys user using the UTL_MAIL package, and it works fine. But I have two issues.

      1. I need to attach a result of a query(query to get the failed jobs) to the email without writing it to a file. Is this possible?

      2. Although I was successful in sending the email with the sys user. I was not able to send a mail using a different user. Is there any particular roles that has to be granted a the particular user to do this?

      Hope that you can help me with this issue.

      Thanks in advance.