Per this thread ....
Apex Mail queue won't send eMail
-- I added a reply to that thread but am resending as its own question ...
The DB in question is this version ...
PRODUCT VERSION STATUS
---------------------------------------- --------------- ----------------
NLSRTL 11.2.0.3.0 Production
Oracle Database 11g Enterprise Edition 11.2.0.3.0 64bit Production
PL/SQL 11.2.0.3.0 Production
TNS for HPUX: 11.2.0.3.0 Production
I have what I think is the same problem ... APEX_Mail won't send. I don't know what to do ... and I don't understand the above "I switched user" answer. How do I "Switch user" ?? I logged into my APEX Workspace, in SQL command box I execute a send statement (as per earlier statements above (in that question link), no magic / issue there), then I select * from the mail queue ... and it shows a set of messages all with ORA-24247 errors. When I push the queue, it just increments the count.
I _have_ an XML / ACL list, created by our System / Enterprise DBA group. I have added connect / resolve privilege for all the developer users (5 of us, in this workspace), I granted these to PUBLIC, to the APEX_040200 user/workspace, to our "master" ID / schema ... and when I list the privileges ... ALL of these grants show up ... so _something_ succeeded.
I even granted connect / resolve to the maste Object-creation schema in which all of the application resides and which runs _just_fine_normal_ behind Oracle Forms ... AND ... we also have the UTL_Mail package installed in this database too. From within our Forms application, or from SQL Plus ... UTL_Mail works _just_fine_ (I tell you this, so you know I am not entirely clueless). AND SMTP per se also works fine (which means the mysterious "port" settings are correct, yes?). Does THIS ACL list work differently?
I am at wits end here ... I don't know how to ask the question, I only know I cannot send email from within APEX, as APEX seems to have been designed to do. I just keep getting ORA-24247 errors.
What should I look at? What should I do next? Why is this so hard? Why isn't there a direct way from within APEX to set / reset these privileges in a _CLEAR_ manner? Sigh.
Thanks for your time and help with this ...
Kind regards all,
Suzanne
(Maybe the APEX team will make this easier to manage in future versions?
Is there a feature request page?)