premkumark

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

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