wood burning stoves 2.0*
The moose likes JDBC and the fly likes java.sql.SQLException: ORA-20001: ORA-01801: date format is too long for internal buffer Big Moose Saloon
  Search | Java FAQ | Recent Topics | Flagged Topics | Hot Topics | Zero Replies
Register / Login


Win a copy of OCM Java EE 6 Enterprise Architect Exam Guide this week in the OCMJEA forum!
JavaRanch » Java Forums » Databases » JDBC
Bookmark "java.sql.SQLException: ORA-20001: ORA-01801: date format is too long for internal buffer" Watch "java.sql.SQLException: ORA-20001: ORA-01801: date format is too long for internal buffer" New topic
Author

java.sql.SQLException: ORA-20001: ORA-01801: date format is too long for internal buffer

Ravissant Markandey
Ranch Hand

Joined: Oct 24, 2007
Posts: 41
Hi Everyone,

Im passing java.sql.Date object to a procedure to do something but it keeps throwing the following error : java.sql.SQLException: ORA-20001: ORA-01801: date format is too long for internal buffer.

What bothers me is that the same code(EAR) is working on my local server but not on the remote(Test) server.I've tried using both setDate() and setObject() for passing the date to the procedure.The procedure returns a boolean .

Please Help!

Regards,
Ravissant

 
jQuery in Action, 2nd edition
 
subject: java.sql.SQLException: ORA-20001: ORA-01801: date format is too long for internal buffer