Skip to Main Content
Forums

APEX

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

How can I send emails with GMAIL?

Hi,
I have an email that I want to use to send emails (I used it in PHP - Laravel and it worked perfectly), but in APEX I can't send emails and as you can see this is my configuration (I don't know if I am missing something else):
image.pngBut I see that the mails stay in QUEUE:
image.pngThis is the PL/SQL block that I am using to check if sending a mail works or not:

begin


apex_mail.send


(p_to=>'cartechco2020@gmail.com',


p_from=>'edisonlopez1400@gmail.com',


p_subj=>'Welcome Emailer',


p_body=>'Welcome to Oracle Apex Sending Emailer Session');


APEX_MAIL.PUSH_QUEUE;


end;


/

Thx.

Comments

843834
Your idea is interesting. But then, XML is an SGML derivative that follows standards laid down by its parent. I guess what you are suggesting is another standard.

I do not completely agree with ur point that XML start & end tags duplicate information. Rather it improves readability of the document.

Its always better to say bValidationRequired than bValReq, the intrepretations could vary on the latter.


Just my thoughts.
843834
Hi Sanjaya,
in ur case there are only 2 elements. when there are lot of elements in ur xml file, not ending with the closed tag with the element name will lead to a confusion & especially when u start writing transformations it would be more tedious.
cheers
anand
843834
Hi All:

I think you missed a point!! Why do I want readability. I think I am not going to write Email in XML:-):-). It is data exchange mode between programs. I think in that case I will have to say: TCP/IP is not readable :-).

AT least for those cases, where programs talk to each other, you DO NOT need human readability.

Nice to hear all your ideas. So nice....

-Sanjay
843834
Hey Sanjay,

Well you mentioned that readability in XML scores low when it is used for exchanging data. I am pretty sure that XML is NOT only intended for data exchange. It is useful in other situations too. Think of XML Content Mgmt (just to say). You definitely need readability here, thou the actual content may be published in a totally diff way.

XML's main purpose is to have custom document structure. It is data/Content driven. Anything that is data centric, MUST be readable too. Why do you have custom document structure is another question and ur point (data exchange) comes into picture as well :-).

Do you agree now?

Srini.
1 - 4

Post Details

Added on Nov 29 2021
#apex, #apex-discussions, #email, #oracle-apex, #pl-sql
7 comments
2,871 views
1 mention