5 Replies Latest reply on Dec 14, 2012 10:13 AM by 846231

    UTL_SMTP Mail

    846231
      Hi all,


      11.2.0.1


      I lost my post again.
      I posted few days ago here about....How to send and email or attachement that is and output of a query , like I want to email to DB Admin all users whose password will expire in 7 days.

      So the output of this query will be emailed to him:

      SELECT username,expiry_date FROM dba_users WHERE expiry_date-sysdate<=7;

      But I can not find it anymore :(

      Thanks,
      Kinz
        • 1. Re: UTL_SMTP Mail
          sb92075
          http://www.lmgtfy.com/?q=google+tutorial
          1 person found this helpful
          • 2. Re: UTL_SMTP Mail
            JustinCave
            If you click on the link that is your name, you'll get a listing of all the posts you've made. Looking very briefly at the questions you've asked, I'm guessing you're talking about Password expiry notification.

            If you search on UTL_SMTP, you'll find a ton of articles that discuss how to send email from within the database using that package. Such as this askTom question.

            Justin
            1 person found this helpful
            • 3. Re: UTL_SMTP Mail
              EdStevens
              KinsaKaUy? wrote:
              Hi all,


              11.2.0.1


              I lost my post again.
              I posted few days ago here about....How to send and email or attachement that is and output of a query , like I want to email to DB Admin all users whose password will expire in 7 days.

              So the output of this query will be emailed to him:

              SELECT username,expiry_date FROM dba_users WHERE expiry_date-sysdate<=7;

              But I can not find it anymore :(

              Thanks,
              Kinz
              Of course, better than utl_smtp would be utl_mail. It acts as a wrapper around utl_smtp and hides a lot of the ugly details. You'd be very well advised to use utl_mail instead of utl_smtp.
              1 person found this helpful
              • 4. Re: UTL_SMTP Mail
                Girish Sharma
                Or may be you are looking for your thread:
                Re: Expired password

                Regards
                Girish Sharma
                1 person found this helpful
                • 5. Re: UTL_SMTP Mail
                  846231
                  I thank you all,

                  I tried search that previous post of mine because there was a suggested solution on how to email a message that is an output of an sql query. :(