GeeCON Prague 2014*
The moose likes JDBC and the fly likes ORA-01858: a non-numeric character was found where a numeric was expected Big Moose Saloon
  Search | Java FAQ | Recent Topics | Flagged Topics | Hot Topics | Zero Replies
Register / Login


JavaRanch » Java Forums » Databases » JDBC
Bookmark "ORA-01858: a non-numeric character was found where a numeric was expected" Watch "ORA-01858: a non-numeric character was found where a numeric was expected" New topic
Author

ORA-01858: a non-numeric character was found where a numeric was expected

Pavan Kumar
Greenhorn

Joined: Jan 13, 2002
Posts: 8
Hi I am facing problem ,while executing stored procedure,I am sending date as java.sql.Date.valueOf("2003-12-19"). It is giving following error
a non-numeric character was found where a numeric was expected.
how to solve this problem?
regards
Hari.


pavan kuamr
Jamie Robertson
Ranch Hand

Joined: Jul 09, 2001
Posts: 1879

since there is nothing wrong with the code you have posted, it is best that you post the Exception message, stack trace, a small code snippet that includes the Callable statement and relevant JDBC code as well as identifying the line throwing the exception. Help us help you!
Jamie
 
GeeCON Prague 2014
 
subject: ORA-01858: a non-numeric character was found where a numeric was expected