This content has been marked as final. Show 5 replies
If you have created a unique key constraint on the db for this table this should be automatically assured. There no other action required by you. You can check if the constraint is transferred to the EO by opening it and open the 'business rules' node. There you should see the rule for the unique constraint nad can alter the message you get in case someone violates it.
See the John's answer to this question: How to do Unique Key Validation
After that see "How to Customize Error Messages for Database Constraint Violations" in this link: http://docs.oracle.com/cd/E16764_01/web.1111/b31974/bcadvgen.htm#sthref2972
see i am insertig same name but using diffrent like some time small and big.so it should take onle one unique name.
see some cases i have written DAMBY and some cases i have written damby. it should should show error unique violated.
i mean i want store same name either uppercase or lower case
Well, in that case you can create a custom validator and validate if there is already (in Database/Memory) another row with that name.
Check this out: http://jjzheng.blogspot.com.es/2010/10/create-custom-validators-in-adf.html