CREATE TABLE xxc_table1(history_id NUMBER,
                        creation_date DATE,
                        program_name varchar2(100)
                        );
 
insert into xxc_table1 values(100,sysdate,'Nothing');
 
insert into xxc_table1 values(200,sysdate-1,'Nothing');
 
insert into xxc_table1 values(201,sysdate-2,'Nothing');
 
select * from xxc_table1
 
LOV Query:-
-----------
SELECT DISTINCT creation_date
FROM xxc_table1
WHERE program_name =nvl(:program_name,program_name)
 
In the LOV I am getting date as '17-NOV-09'

In the FIND BUTTON Query:-
---------------------------
select HISTORY_ID
 from xxc_table1
where program_name='Nothing' --Parameter
  and trunc(creation_date)=to_date (:creation_date, 'DD-MON-RR');
 --and creation_date=:BLOCK502.creation_date; 
 --and trunc(creation_date)=to_date (:BLOCK502.creation_date, 'MM/DD/YYYY');
 --and to_char(creation_date,'DD-MON-YY')=to_char(:BLOCK502.creation_date,'DD-MON-YY');
 --and creation_date = to_date(:BLOCK502.creation_date, 'DD-MON-YYYY'); 
 --and trunc(creation_date)=to_date (:BLOCK502.creation_date, 'DD-MON-RR'); 

After selected the LOV any one of the LOV and clicked on the Button i am getting below error
frm-40735 unhandled exception ora-01403