presenting user-friendly error messages

From: Thomas Blankschein <thomas_at_blankschein.de>
Date: Fri, 10 Dec 2004 09:43:30 +0100
Message-ID: <cpbnjp$ins$01$1@news.t-online.com>

Hello,

an Oracle-DB with several constraints does complain correctly if a user tries to insert data over the frontends which do not fit to the check constraints. Unfortunately in such a case only an message like 'ORA-XXXX Constraint CHK_CUSTOMER_ID violated' is displayed. How can I present a more informative message to the user with a description of the error and hints to avoid it? And this independend from the frontend? My first thought is an additional table in the database with all the constraint names and corresponding text messages in it. In case of an error every frontend has to read this information from the table and displays it to the user.

Thanks,
Thomas Received on Fri Dec 10 2004 - 02:43:30 CST