Aubrey Fernandes wrote:What do you mean by "Oracle Apex Instance name"? As far as I know, not only is there no such substitution string, but there's no property anywhere in APEX for specifying an "instance name".
We have an Application that will be replicated in multiple Apex instances and would like to display the current Oracle Apex Instance name ( Similar to the &APP_USER. on the Welcome portion of the page ) .
Is there a substitution string for this ?
We plan on using a Show/Hide region on the splash page titled [About], that when clicked displays an HTML region with the subsitution strings.
If no substitution strings, can someone help with an SQL that returns the Instance name ?
Aubrey Fernandes wrote:That information is determined by the web server configuration (e.g. the DADs when using OHS) rather than through APEX itself. There are no built-in substitution strings for this. Create an application item and an On New Instance (new session) computation to set the value using the function<tt>owa_util.get_cgi_env</tt> function to get the CGI environment variables <tt> HTTP_HOST</tt> and <tt>SCRIPT_NAME</tt>. You can then reference the value in the region using substitution string syntax.
I currently have 3 URLs to get to my Development, QA and Production servers & will have many more production servers with different Application Ids.
Development = http://canqa101:7777/pls/ngcrmd01/apex
QA = http://canqa101:7777/pls/ngcrmq01/f?p=100:1
Production = http://cancs105:7777/pls/ngcrmp01/f?p=100:1
What I need are the portions before the final forward slash ( canqa101:7777/pls/ngcrmd01 ) which I assumed is the Oracle Apex instance.