APEX

Hello.

I am probably asking a question that has been asked a million times. I have browsed through the thread but the only answers I see are hacks, work-around and complicated coding digressions for a seemingly simple subject - exception handling.

Specifically, if I have a form that fails because of a trigger or or unique constraint violation, or experiences any ORA- (for that matter) on submit, is there a way to have ApEx render a manually coded error page instead of it displaying the acutal ORA- on the error page it automatically generates?

I am looking for a sort of a "catch-all" category for exception handling, so that in case of any database-side error the page comes across, it redirects to a page with a user-friendly message that I can control.

thanks
Boris