Ever wanted to programmatically create and use a valid APEX session ID? Well, one way to get a session ID is to let the database act as a browser and let it request the contents of a public APEX page. In this page, the session ID is stored and can be easily retrieved. Try it out yourself. But be aware: it only works for public APEX pages!
Niels de Bruijn, MT AG, Germany.
Here is the PL/SQL function: call_public_apex_page
