APEX

Hello,

I have problem with my report query. Like, I have a report which gives results based on a filter review_dt (which is a select list with submit item). The report is working fine and getting the results when i select any review_dt from the select list; but when the select list is null(i.e; it contains null value as %) its giving me an error saying.

report error:
ORA-01858: a non-numeric character was found where a numeric was expected

I am not able to understand what might be the problem. I think my report query has a problem when dealing with nulls.

Below is my report source query.

select apex_item.hidden(05,CHF_DATASTORE||CHF_SCHEMA||CHF_TABLE||CHF_REVIEW_TYPE||to_date(CHF_REVIEW_DT,'DD-MON-RR'),'','f05_' || ROWNUM)
|| APEX_ITEM.MD5_HIDDEN(45,CHF_REVIEW_DT,CHF_REVIEW_TYPE,CHF_REVIEW_STATUS,CHF_REVIEW_SID,CHF_REVIEW_SUMMARY)
|| APEX_ITEM.HIDDEN(04,ROWNUM,'','f04_' || ROWNUM) " ",
CHF_UPDATE_SID,
CHF_UPDATE_DT,
APEX_ITEM.SELECT_LIST_FROM_QUERY_XL(22,CHF_REVIEW_DT,'select max(chf_review_dt) d, max(chf_review_dt) r from chf_table_review where chf_datastore=:P0_DATASTORE and chf_schema=:P0_SCHEMA and CHF_TABLE=:P0_TABLE and chf_review_type=:P3_CHF_REVIEW_TYPE
order by 1',NULL,'YES',NULL,'-Select Review Date-','f22_' || ROWNUM) CHF_REVIEW_DT,
APEX_ITEM.SELECT_LIST_FROM_QUERY_XL(23,CHF_REVIEW_TYPE,'select distinct CHF_REVIEW_TYPE d, CHF_REVIEW_TYPE r from chf_table_review where chf_review_type=:P3_CHF_REVIEW_TYPE
order by 1',NULL,'YES',NULL,'-Select Review Type-','f23_' || ROWNUM) CHF_REVIEW_TYPE,
APEX_ITEM.SELECT_LIST(24,CHF_REVIEW_STATUS,'In Review;In Review,Approved;Approved',NULL,'YES',NULL,'-Select Review Status-','f24_' || ROWNUM) CHF_REVIEW_STATUS,
APEX_ITEM.SELECT_LIST_FROM_QUERY_XL(25,CHF_REVIEW_SID,'select distinct T.chf_REVIEW_SID || '' - '' ||P.chf_person_name d, T.chf_REVIEW_SID r from chf_TABLE_REVIEW T left join chf_Person P on (P.chf_person_sid = T.chf_REVIEW_SID ) order by 1',NULL,'YES',NULL,'-Select Review Status-','f24_' || ROWNUM) CHF_REVIEW_SID,
APEX_item.textarea(26,CHF_REVIEW_SUMMARY,4,150) CHF_REVIEW_SUMMARY
from CHF_TABLE_REVIEW
WHERE CHF_SCHEMA = :P0_SCHEMA AND
CHF_DATASTORE = :P0_DATASTORE AND
CHF_TABLE = :P0_TABLE AND
CHF_REVIEW_TYPE = :P3_CHF_REVIEW_TYPE AND
to_date(CHF_REVIEW_DT,'DD-MON-RR') = :P3_CHF_REVIEW_DT
order by chf_update_dt
--------------------------------------------------------------------------------------------------
P3_CHF_REVIEW_DT is my select list with submit item

can anyone please help me out with this issue.

Thanks,
Orton