Debugging Oracle Application Express can be a conundrum.
It’s PL/SQL, but I cannot see it, and I cannot step through it. PL/SQL generates the page, but I do not have access to the APEX page generator. Where to start?
The truth is there are many avenues for debugging APEX, some APEX-supplied, some external to APEX.
The paper and presentation APEX Debug Options describes both APEX-supplied utilities and tools external to APEX for debugging APEX applications.
Get the paper here: APEX Debug Options
See this presentation at the New York Metro Area Oracle User Group 2008 Training Day on September 10, 2008 at the New Yorker Hotel, New York City.
See you there!
If you can’t make it, email me for the presentation, and I’ll post it here.