Forgot Password

Lost your password? Please enter your email address. You will receive a link and will create a new password via email.

Have an account? Sign In Now
Sign InSign Up

OrclQA.Com

OrclQA.Com Logo OrclQA.Com Logo

OrclQA.Com Navigation

  • Oracle
  • Oracle Apex
  • Python
  • Questions
Search
Ask A Question

Mobile menu

Close
Ask a Question
  • Ask Question
  • Add Post
  • Oracle
  • Oracle Apex
  • Python
  • Questions
Zulqarnain Haider
Zulqarnain Haider

Zulqarnain Haider

  • 8 Questions
  • 17 Answers
  • 0 Best Answers
  • 81 Points
View Profile
  • 1
Zulqarnain HaiderProfessional
Asked: November 11, 20202020-11-11T19:22:05+05:30 2020-11-11T19:22:05+05:30

How to send Email in Oracle Apex

  • 1

Hi Sir

I want to send email In Oracle apex Kindly Provide the Step.I configure ACL and UTL_SMTP but

email Not send.

apexemail
  • 6
  • 408
  • 0
  • 0
  • Share
    • Share on Facebook
    • Share on Twitter
    • Share on LinkedIn
Answer

6 Answers

  1. Aru

    Aru

    • 2 Questions
    • 2 Answers
    • 0 Best Answers
    • 37 Points
    View Profile
    Aru Contributor
    2020-11-12T09:26:26+05:30Added an answer on November 12, 2020 at 9:26 am

    Hi,

    Are you hitting with any errors while trying to send email

    Are you able to send mails successfully using UTL_SMTP

    Regards

    Aru

    • 0
    • Share
      Share
      • Share on Facebook
      • Share on Twitter
  2. Zulqarnain Haider

    Zulqarnain Haider

    • 8 Questions
    • 17 Answers
    • 0 Best Answers
    • 81 Points
    View Profile
    Zulqarnain Haider Professional
    2020-11-16T17:41:02+05:30Added an answer on November 16, 2020 at 5:41 pm

    Hi Aru

    This error when i Send Emai.

    ORA-29279: SMTP permanent error: 503 5.5.1 bad sequence of commands

    • 0
    • Share
      Share
      • Share on Facebook
      • Share on Twitter
    • Vinish Kapoor

      Vinish Kapoor

      • 1 Question
      • 727 Answers
      • 63 Best Answers
      • 4k Points
      View Profile
      Vinish Kapoor Enlightened
      2020-11-16T18:22:19+05:30Replied to answer on November 16, 2020 at 6:22 pm

      Please show the PL/SQL code you are executing.

      • 1
      • Share
        Share
        • Share on Facebook
        • Share on Twitter
  3. Zulqarnain Haider

    Zulqarnain Haider

    • 8 Questions
    • 17 Answers
    • 0 Best Answers
    • 81 Points
    View Profile
    Zulqarnain Haider Professional
    2020-11-17T12:37:51+05:30Added an answer on November 17, 2020 at 12:37 pm
    Declare
    l_body clob;
    l_body_html clob;
    begin
    l_body := 'To view the content of this message, please use an HTML enabled mail client.' || utl_tcp.crlf;
    
    apex_mail.send (
    p_to => '[email protected]', -- change to your email address
    p_from => '[email protected]', -- change to a real senders email address
    p_body => l_body,
    p_body_html => l_body_html,
    p_subj => 'APEX MAIL' );
    
    apex_mail.push_queue();
    
    end;
    • 0
    • Share
      Share
      • Share on Facebook
      • Share on Twitter
    • Vinish Kapoor

      Vinish Kapoor

      • 1 Question
      • 727 Answers
      • 63 Best Answers
      • 4k Points
      View Profile
      Vinish Kapoor Enlightened
      2020-11-17T12:59:00+05:30Replied to answer on November 17, 2020 at 12:59 pm

      Your code seems ok. I ran and got the email.

      Try login into Oracle Apex administration services and click on the Instance setting. There you need to check by changing the configuration settings.

      • 1
      • Share
        Share
        • Share on Facebook
        • Share on Twitter
  4. Zulqarnain Haider

    Zulqarnain Haider

    • 8 Questions
    • 17 Answers
    • 0 Best Answers
    • 81 Points
    View Profile
    Zulqarnain Haider Professional
    2020-11-18T11:55:02+05:30Added an answer on November 18, 2020 at 11:55 am

    Hi Sir Vinish

    My Intance Setting is ok.Its possible to Send your ACL and UTL_SMTP then i will check what i am wrong.

    • 0
    • Share
      Share
      • Share on Facebook
      • Share on Twitter

You must login to add an answer.

Forgot Password?

Sidebar

Explore

  • Ask Question
  • Add Post

Creative Commons License
This work is licensed under a Creative Commons Attribution-NonCommercial-ShareAlike 4.0 International License.
© 2022 OrclQA.Com. All Rights Reserved.
Privacy Policy - About Us