Redirect to URL

Redirect to another page within APEX, or to a new URL, using PLSQL.

The code may be useful in a before header process.

apex_application.g_unrecoverable_error ensures that any further rendering of the page, or processing on that page, stops.

 owa_util.redirect_url('f?p=' || v('APP_ID') || ':HOME:' || v('SESSION'));
 apex_application.g_unrecoverable_errorĀ := true;

An alternative way to stop processing is to use

apex_application.stop_apex_engine;

The preferred way of doing this is now using APEX_UTIL.REDIRECT_URL

APEX_UTIL.REDIRECT_URL('f?p=' || v('APP_ID') || ':HOME:' || v('SESSION'));