Hi everybody,
I am trying to send email from Oracle APEX 22.2 using email delivering services from OCI. Configuration from OCI show me all checked, that is correct. But email messages never go out from the queue.
But if I use UTL_smtp from Database Actions, email is sent. Only fail using apex_mail.
When I run the follow script:
ALTER SESSION SET CURRENT_SCHEMA = APEX_200200;
select name, value from apex_instance_parameters
where name like 'SMTP%' order by name;
DB show that:
And it's correct.
When i try to run:
ALTER SESSION SET CURRENT_SCHEMA = APEX_200200;
BEGIN
APEX_INSTANCE_ADMIN.VALIDATE_EMAIL_CONFIG;
END;
/
I receive the next error:
ORA-29019: La versión del protocolo no es correcta.
ORA-06512: en "SYS.UTL_TCP", línea 63
ORA-06512: en "SYS.UTL_TCP", línea 331
ORA-06512: en "SYS.UTL_SMTP", línea 215
ORA-06512: en "SYS.UTL_SMTP", línea 239
ORA-06512: en "APEX_220200.WWV_FLOW_MAIL", línea 1251
ORA-06512: en "APEX_220200.WWV_FLOW_MAIL", línea 2601
ORA-06512: en "APEX_220200.WWV_FLOW_INSTANCE_ADMIN", línea 1660
ORA-06512: en línea 2 Error at Line: 11 Column: 0
This is my queue
I tried pushin queue by PL/SQL apex_mail and it not sent.