Programmatically determine hostname and port for APEX via PL/SQL
Hi,
Is it possible to get the host name (and port) of the current APEX instance programmatically using PL/SQL?
The reason I ask is that I prepare emails using the APEX_MAIL API for one of my applications, and rather than hard-code (or use substitution strings) the URL to the APEX application in the PL/SQL block that generates and sends the email, I would like to make it dynamic, so migrating it from a development APEX host to a production APEX host doesn't require changing these values.
Any Ideas?
Cheers,
Hayden