moki
Programmer
- Dec 5, 2000
- 37
Is there a way to intercept constraint and/or trigger messages before it is displayed to the user.
Example: Oracle Database field Last_Name Varchar2(25) Not Null.
The user leaves the row before entering the Last_Name.
In this case I would like to replace the constraint message displayed: ORA-01400: Cannot insert Null into ("Schema.TableName.Last_Name") with a messsage such as "The Last Name field must have a value.
Thank you in advance.
Example: Oracle Database field Last_Name Varchar2(25) Not Null.
The user leaves the row before entering the Last_Name.
In this case I would like to replace the constraint message displayed: ORA-01400: Cannot insert Null into ("Schema.TableName.Last_Name") with a messsage such as "The Last Name field must have a value.
Thank you in advance.