Show CGI Environment in APEX

November 23, 2022

apex, debugging, oracle, ords

This simple tip may help you troubleshooting integrations in APEX and ORDS.

Show CGI Environment in APEX

I have been struggling with integration issues in APEX lately. Listing out the CGI environment helped to identify the probable cause.

Just create a region of type Dynamic Content and add this code:

begin
   OWA_UTIL.PRINT_CGI_ENV;
end;

It will list values for HTTP_SERVER, HTTP_PORT, etc. If the configuration on your reverse proxy is wrong, it will likely show up here with values that will not work in the external world.

Screen capture from APEX.