So, for lack of a better way of putting it, I have a need to have user input durring the script install part of the supporting objects. I would like to use the Substitution String prompts but can not figure out where it stores the values durring install. It looks as if the system does not commit it to tbl until after the install scripts are done.
I need to create some views that have a different Databaselink based on site location and want the supporting object install scripts to prompt for the name so I can use it in the install process.
Testing on APEX 4.0.1 Oracle 11g
Thanks for any help.