[ORA-01843: not a valid month]

Hi,

 

sorry i missed the quote while typing in the forum, but the qoute is present in my work code.

 

thanks,

kumar

[ORA-01843: not a valid month]

Hi, 
 
I am getting the following error when i try to run a report with date parameter. 
 
The report was created using jasper reports and the database is Oracle 10g. 
 
i am using the following query in the report.. 
 
SELECT ANALYSIS_NAME, ANALYSIS_RESULT FROM ANALYSIS WHERE RECEIVED_DATE =  
TO_DATE($P{START_DATE}, MM/DD/YYYY) 
 
I ran this query in TOAD its working fine but when i run the report its throwing an error saying "ORA-01843: not a valid month" 
 
Thanks, 
Kumar