Change default error message on check constraint

Hi,

[10g/Win]

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)
violated"

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