APEX_MAIL / HTMLDB_MAIL Failing Unexpectedly
(Doc ID 434137.1)
Last updated on FEBRUARY 09, 2023
Applies to:
Oracle Application Express (APEX) - Version 2.0 and laterInformation in this document applies to any platform.
Symptoms
APEX_MAIL (or HTMLDB_MAIL) is not working correctly when called from a DBMS_SCHEDULER job which calls the send email procedure. The error that is seen in SQLPLUS is:
This procedure used to return a Workspace ID, but is now failing. The purpose of WWV_FLOW_API.SET_SECURITY_GROUP_ID is to set the package variable that contains the workspace ID of a workspace to which the schema is assigned. After this package variable is set, the security check in the mail package is satisfied that an authorized caller invoked it. Since WWV_FLOW_API.SET_SECURITY_GROUP_ID is no longer returning a valid workspace ID, the APEX_MAIL package is failing.
Cause
To view full details, sign in with your My Oracle Support account. |
|
Don't have a My Oracle Support account? Click to get started! |
In this Document
Symptoms |
Cause |
Solution |