Databases Reference
In-Depth Information
Error handling
In Application Express, error handling is dramatically improved. You can deine
how exceptions are handled in your application instead of being constrained by the
APEX engine itself.
This feature can be used if a developer wants to have full control of the error
handling when an error occurs in an APEX application. It can not only be used to
just log the error, but also for modifying the error message text. You can also deine
where the message should be displayed.
(Inline with Field and in Notiication: Error messages display in notiication
area; Inline with Field: Error messages displayed within the ield label; Inline in
Notiication: Error message display in the #notifcation_message substitution string
or at a speciic Error Page.) It is also possible to specify which page item/tabular
form column should be highlighted.
1.
Install the sample database application.
2.
Review the
DEMO_ERROR_HANDLING
function.
3.
Rename and tweak to meet your requirements.
4.
Modify your application properties to use the
Error Handling
function:
Logging and tracing
It can be quite dificult to debug slow regions or reports. A trace ile can help to
analyze the slow performance. Append
&p_trace=YES
to the URL, as follows:
http://hostname:port/apex/f?p=appid:pageid&P_TRACE=YES
grant alter session to APEX_PUBLIC_USER
Otherwise trace ile will not be created.
