APEX Application Item Validation
Irha10Sep 9 2010 — edited Sep 9 2010Hi there,
can anyone help me.
actually i want to do validation to make sure correct data input.
e.g
i have few fields as dates and each date fields divided into two parts so two coloumns .
first part take date as dd/mm/yyyy and this is fine and validation work as i am using 'Item speciified is a valid date' . second part take time as 'HH24:MI' we do enter as 12:12 for example.. therefor I am strulling in time part for validation.
at the moment i am using as follows
'SQL Expression'
substr(:p4_datehh3,1,2) between 00 and 23
AND substr(:p4_datehh3,4,2) between 01 and 59
and its work fine, can not enter value other than above but when enter any character such as 'a','b' or any thing else then getting error but as follows
ORA-06503: PL/SQL: Function returned without value
Error ERR-1023 Unable perform validations.
OK
so i want validation should be display error message on same page not like above.
so please let me know if anyone can help me.
kind regards.