Skip to Main Content

Oracle Database Discussions

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

Can I replace user defined message at database level when table constraint

405676Oct 6 2005 — edited Oct 6 2005
Hello all,

Can I replace user defined message at database level when table constraint fails?

e.g.

The “Emp” table has constraint like emp_basic_salary_ck check (basic_sal > 0)

When it fails I want to replace user defined message (Basic salary must be greater then zero) over to default message generated by database.


From
Chirag Patel
Comments
Locked Post
New comments cannot be posted to this locked post.
Post Details
Locked on Nov 3 2005
Added on Oct 6 2005
14 comments
726 views