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
Want to check out a professional solution based on APEX? Then check out our Time Management System:
http://www.apexsolutions.info/time.
Time Management System is a professional online time-recording & reporting tool for midsize companies. This cost-free and fully customizable solution is used for years by a consultany company in Germany with over 200 employees. The intuitive user-interface enables managers to stay up to date by accessing one of the many available reports in realtime. Just import the application in your APEX 3.2.x environment and run it. Demo data is already provided, so you can explore the application immediately.
If you have any questions, feel free to contact me.