This week's book giveaway is in the Servlets forum.
We're giving away four copies of Murach's Java Servlets and JSP and have Joel Murach on-line!
See this thread for details.
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 Murach's Java Servlets and JSP this week in the Servlets 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

 
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
can bind a LONG value only for insert into a LONG column
java.sql.SQLException: ORA-01830: date format picture ends before converting entire i
Error while inserting data
Passing specific format date to callable statement
Don't work spatial index