Get your CodeRanch badge!*
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
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

 
I agree. Here's the link: http://aspose.com/file-tools
 
subject: java.sql.SQLException: ORA-20001: ORA-01801: date format is too long for internal buffer
 
Similar Threads
Error while inserting data
Don't work spatial index
java.sql.SQLException: ORA-01830: date format picture ends before converting entire i
Passing specific format date to callable statement
can bind a LONG value only for insert into a LONG column