APEX

hi

I have found that my item level validations on a page are not working as I expected. I validate a field (P74_change_id) to 'must be numeric', then I have another validation with a much higher sequence number that checks whether the value already exists in the database, but this is causing an error if the value if not numeric. The following text is taken from my debug mode, what surprises me is the second line that clearly states the first 'not numeric' validation is functioning correctly and returning a fail, but it still carries on with the other validations.

0.28: ...Item is numeric validation: P74_CHANGE_ID
*0.28: ...Validation did NOT pass*
0.28: ...Item Not Null or zero Validation: P74_CHANGE_ID
0.28: ...Item Not Null Validation: P74_RAISED_DATE
0.29: ...Item is date validation: P74_RAISED_DATE
*0.29: ...Validation did NOT pass*
0.29: ...Item Not Null Validation: P74_APPROVED
0.29: ...Item Not Null Validation: P74_TYPE
0.29: ...Item is date validation: P74_APPROVED_DATE
0.30: ...Exists Validation: type="NOT_EXISTS" select * from budget_ct_header where (change_ID = :P74_change_Id) and (change_ID_rev = :P74_change_id_rev) and (project = :P74_project) and (type = :P74_TYPE)
0.30: Show ERROR page...


I get a 'ORA-01722: invalid number' and 'Error ERR-1006 Error in validation routine' referring to 'Exists Validation: type="NOT_EXISTS" select * from' etc the on the page below the debug.

Any ideas/thoughts??

Thanks

-Marc