Skip to Main Content

APEX

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

APEX Application Item Validation

Irha10Sep 9 2010 — edited Sep 9 2010
Hi 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.
Comments
Locked Post
New comments cannot be posted to this locked post.
Post Details
Locked on Oct 7 2010
Added on Sep 9 2010
8 comments
2,758 views