Skip to Main Content

APEX

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

Setting instance URL

Alwyn CUApr 19 2023

Database: 19c EE (19.0)

Apex: 20.2

Hello, in some of my environments, the following calls return something but null in others. I am assuming the instance URL is not set in the environments returning null.

  1. Where exactly is the instance URL set? The Instance Administrator and I had a look around the Administration pages but could not see anything obvious.
  2. If not that, what setting should we check and where?

SELECT apex_mail.get_instance_url val FROM DUAL;

OK env = https://domain/ords/db/

Not OK env = <null>

SELECT apex_util.host_url('APEX_PATH') val FROM DUAL;

OK env = http://:https://domain/ords/db/

Not OK env = http://:

~ Alwyn

This post has been answered by Ed Jones-Oracle on Apr 19 2023
Jump to Answer
Comments
Post Details
Added on Apr 19 2023
2 comments
810 views