Hi. I have 2 page items namely P2_DNAME and P2_LOCATION. Both are text fields.What I want to do is I need to create a validation. The P2_DNAME field must be unique.When entered a value in that field, it should check with the DEPT table and make sure it has unique name.
To achieve this I have created a validation named Unique dept name. Which checks with the query 'select 1 from dept where dname=:P2_DNAME' and throws an error message. Also this validations is executed when the submit button is clicked. But I want this to be executed when the user moves to the next field.
My validation is also not working. I have reproduced this in oracle apex.com
WORKSPACE:XXKIRAN
USERNAME:kiran28.d1@gmail.com
PWD:kiran123
App.No:94949
Page No:2
Can someone please review and tell me what am I missing?