APEXblog.nl - Tips and Tricks

About This Blog:
I (Richard Weug) started this blog primary for myself to save all kinds of Apex tips and tricks in one place. To use it as a place to write down how I used some coding in my own projects, but also to copy and paste all kinds of articles I find on the Internet. (So I never have to wonder on what website did I read about??? When I see something interesting I collect the content so I have my own archive/knowlegde base.

View my profile on LinkedIn


Tips & Tricks


Branch to procedure/Function return page id

Written by Richard Weug. Posted in Tips and Tricks

There are several "Branche To" options. One of them is the "Branch to procedure", but remember, when you want to use this as a branch to fire up a procedure, that the Apex user will end up on a black screen if you only perform database actions.
You can also use Branch to Function returning page ID. With this branch, you can still execute your procedure and sent after processing, the user to a specific page.

A nice way to do this is maybe setting an application variable F_PAGE_ID.
Create a PL/SQL process that runs before header of the page

content:   select :APP_PAGE_ID into :F_PAGE_ID from dual;

In the branch to function you can now do something like:

return :F_PAGE_ID;