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!

How to Dynamically construct a URL?

Harry83Apr 18 2010 — edited Apr 20 2010

I have a button that calls url of a page in another application:

http://biotite.agso.gov.au:7777/pls/apex_dev/f?p=159:1

We have three database environments, ie. Dev, test, production. So, the url will be different in Test and Prod environments:

http://biotite.agso.gov.au:7777/pls/apex_test/f?p=159:1

http://biotite.agso.gov.au:7777/pls/apex_prod/f?p=159:1

With Change Management and Release Control in place, I cannot modify any codes in Test and Production environment. This has caused a problem. The url that points to a APEX page is hard coded, and will not point to right environment when the application is released to new environment. Is there any way to construct URL dynamically ? for example, using an application compution to set a variable that sourced from a PL/SQL function to identify which environment it is in. My question is how to concatanate this value to a URL using something like following?

http://biotite.agso.gov.au:7777/pls/apex_#DBENV#/f?p=159:1

Locked Post

New comments cannot be posted to this locked post.

Locked on May 18 2010

Added on Apr 18 2010

#apex, #apex-discussions, #url

6 comments

3,317 views