JDBC Error: ORA-01858
Printed From: Crystal Reports Book
Category: Crystal Reports .NET 2003
Forum Name: Writing Code
Forum Discription: .NET 2003 programming API, report integration
URL: http://www.crystalreportsbook.com/forum/forum_posts.asp?TID=5530
Printed Date: 18 May 2024 at 6:32am
Topic: JDBC Error: ORA-01858
Posted By: nikhil_vb
Subject: JDBC Error: ORA-01858
Date Posted: 16 Feb 2009 at 1:56pm
Hi,
I am trying to integrate crystal reports with a J2EE project. I have a table which has a column "ORDER_DATE" with datatype - DATE. i am trying to get this column using "so.order_date between to_date('{?FromDate}','MM/DD/YYYY') and to_date('{?ToDate}','MM/DD/YYYY')". I pass the dates from my code in this very format "02/03/2009". But when i run the report, I get the error:
com.crystaldecisions.sdk.occa.report.lib.ReportSDKException: JDBC Error:
ORA-01858: a non-numeric character was found where a numeric was expected ----
Error code:-2147467259 Error code name:failed
I have tried removing the date conditions and it seems to work fine without it. I read a lot of forums and they all say that there is something wrong with the date format. Please help with this....
------------- Regards,
Nikhil
|
|