teedub wrote:The basic approach to this in APEX is to use conditions:
All I really want to do is to click a button in order to run some PLSQL and then redirect to the home page.
This would action fire after your "Execute PL/SQL" action and trigger the redirect as soon as the PL/SQL execution comes back.
should actually have been
After changing the substitution variable to HOME_LINK the output looked already better, but HOME_LINK contains a substitution variable (&APP_ID.) itself
That's why I have modified the default clause of your P2_URL and referenced that page item in the dynamic action. If that is getting to complicated, you can also just change your dynamic action to a hard coded page#, which might be more straight forward.