Hi,
I'm running Apex on an Oracle Autonomous Data Warehouse on the Oracle Cloud Services.
I've followed the oracle guide on how to configure and use APEX_MAIL to send and receive email from my apex application using Oracle Cloud Infrastructure as the Email Delivery end-point.
I logged into my apex ws and ran the command below in SQL Workshop and it executed successfully but I did not receive any email.
BEGIN
APEX_MAIL.SEND(p_from => 'me@example.com',
p_to => 'you@example.com',
p_subj => 'Email from Oracle Autonomous Database',
p_body => 'Sent using APEX_MAIL');
END;
/
I checked the MAIL QUEUE when I logged to the apex instance under administration services and saw that there was an error. The error message was "ORA-28759: failure to open file"
I also noticed that I've followed all the steps but when I came to validate the installation by running the following command on SQL Web Developer. I got the error below.
BEGIN
APEX_INSTANCE_ADMIN.VALIDATE_EMAIL_CONFIG;
END;
/
ORA-28759: failure to open file ORA-06512: at "SYS.UTL_TCP", line 63 ORA-06512: at "SYS.UTL_TCP", line 314 ORA-06512: at "SYS.UTL_SMTP", line 458 ORA-06512: at "SYS.UTL_SMTP", line 464 ORA-06512: at "APEX_200200.WWV_FLOW_MAIL", line 1121 ORA-06512: at "APEX_200200.WWV_FLOW_MAIL", line 2411 ORA-06512: at "APEX_200200.WWV_FLOW_INSTANCE_ADMIN", line 1565 ORA-06512: at line 2
It would seem that the SYS.UTL_TCP package does not exist. I've logged into the ADB as the admin user but don't know why I do not have access.
Also, if this package is removed then the Oracle documentation needs to be updated or am I doing something wrong here. Any help here would be very much appreciated.