Oracle APEX currently supports only one SMTP configuration at the instance level. Due to this restriction, if we deploy multiple APEX applications for different customers in the same environment, it creates a major limitation. The email functionality will fail or conflict, as only one SMTP server can be used globally.
In real-world scenarios, especially in multi-tenant environments, different customers might use different email providers or SMTP credentials. There should ideally be support for multiple SMTP configurations, possibly at the workspace or application level.
Has anyone else faced a similar challenge?
Is there any solution or workaround available without using any external email software?
I'm specifically looking for options such as:
- Java stored procedures
- Switching SMTP dynamically within APEX or PL/SQL
- Any approach that allows SMTP isolation between applications within the same APEX instance.
Appreciate your inputs or shared experiences!