This content has been marked as final. Show 2 replies
SQL Query Date statement:
Parameter defined in OTM & in Oracle Reportd :- parameter name "P_H_FROM_Date" (date datatype in otm and oracle reports without any inputmask) Parameter defined in Oracle Reports :- P_L_Date (datatype date without any inputmask)
if value_entered(:P_H_FROM_DATE) then :P_L_DATE := 'AND sh.start_time '||get_filter_condition( :P_H_FROM_DATE, :P_DATE_FORMAT); else :P_L_DATE := 'and 1=1'; end if;
Please help me, I dont know how to resolve this issue and I need to resolve it ASSP.
*Error* REP-546: Value does not match mask 'DD-MON-RR'. ORA-01858: a non-numeric character was found where a numeric was expected REP-0091: Invalid value for parameter 'P_H_FROM_DATE'.