Change default error message on check constraint

From: dean <>
Date: Thu, 28 Feb 2008 09:22:55 -0800 (PST)
Message-ID: <>



Is there a way to change the error message given to a user when a check constraint is violated?

For example, instead of:

"ORA-02290: Check constraint (GC_JAN08.TR_ORIG_T_BEFORE_DEPT_T)

I would prefer to see:

"Error: Origination time must be before departure time."

I realize this can always be done in the app code.

Thanks! Received on Thu Feb 28 2008 - 11:22:55 CST

Original text of this message