How to 'customize' error message from check constraints

Hello,

I am wondering if there is a way to change the default error message when a check constraint is violated. For example:

'fsql> insert into test values('0');
ORA-02290: check constraint (GEORGE.SYS_C001235) violated'

How can I change this to:

ORA-02290: The column 'price' must be greater than 0.

This would be very benifical to the clients who insert data so they know what they did wrong.

Thank you,
George Hart
San Diego

Sent via Deja.com
http://www.deja.com/ Received on Tue Feb 06 2001 - 17:40:55 CST