Skip to Main Content

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!

Does anyone knows APEX's mailbox feature cannot to use?

Max.WongMar 6 2024 — edited Mar 11 2024

I've configured the mailbox and wallet.

When I run the following code to check if the mailbox configuration is correct,

begin
 apex_instance_admin.validate_email_config;
end;
/

I get this error,

ERROR at line 1:
ORA-29279: SMTP permanent error: 502 Invalid input from xx.xxx.xxx.xxx to
xxxx.xx.com.
ORA-06512: at "APEX_230200.WWV_FLOW_MAIL", line 1347
ORA-06512: at "SYS.UTL_SMTP", line 57
ORA-06512: at "SYS.UTL_SMTP", line 142
ORA-06512: at "SYS.UTL_SMTP", line 446
ORA-06512: at "APEX_230200.WWV_FLOW_MAIL", line 1331
ORA-06512: at "APEX_230200.WWV_FLOW_MAIL", line 2656
ORA-06512: at "APEX_230200.WWV_FLOW_INSTANCE_ADMIN", line 1882
ORA-06512: at line 2

When I call apex_mail.send to send an email, the message goes into the mail queue and is not sent, and there is no error message.

I've also looked up a lot of other information, but I can't solve the APEX mailbox configuration problem, what is this problem? How can I fix it?

PS,I am in the database, I can send emails normally with UTL_SMTP.

So, the problem now is that in Oracle Apex, with the same configuration, the email function still doesn't work.

Thanks

This post has been answered by Max.Wong on Mar 14 2024
Jump to Answer
Comments
Post Details
Added on Mar 6 2024
17 comments
594 views