Hi All,
I have strange issue on field(s) validation on apex page.
I have 4 fields on the apex page. after entering all the values and user submit SAVE button on the page, combination of all the fields values validated against Data base table, with this combination of values any record already exists in the table.
it is validated successfully and displayed the custom error message that I have given error message text box.
So now the problem is, after modifying or entering correct values in the fields, trying to click on SAVE button again and still it says same old error message. its not allowing to save the correct record into table.
I have tried with Validation Type PL/SQL Function Body(returning Boolean).
I have also tried validation type PL/SQL error.
I have tried No Rows returned and SQL Expression validation options as well, but it did not worked out.
Script that I have used in validation query.
DECLARE
v_count number(4);
begin
select count(name) into v_count
from table_test
where name= :P12_NAME
and dest =:P12_DEST
and source = :P12_SOURCE
and stat = :P12_STAT;
if v_count >=1 then
return true;
else
return false;
end if;
end;
Please help me to solve this issue.
Thanks.