I have a need to use the APEX_MAIL.SEND to send email out. But the challenge is that the schema that runs the APEX_MAIL.SEND API is not the schema that is assigned to the Workspace. Let's say that I have a workspace called “XYZ”. I have a schema ABC assigned to this XYZ and build the applicaiton that contains Email templates and such.
But I need to connect to the database as schema 123 and run the APEX_MAIL.SEND and use the email template in the XYZ workspace.
Currently, when I run this API, it will say that "ORA-20022: Email template "EMAIL_TEMPLATE" not found in application 601.
I know that I can add schema 123 to the Workspace XYZ. This will solve this issue. But I have other security reason that I cannot add schema 123 to this workspace.
Is there any API that I can call that can allow schema 123 use the APEX_MAIL.SEND without being added to the Workspace XYZ? Any idea is greatly appreciated. Thanks