• Post Reply Bookmark Topic Watch Topic
  • New Topic

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

 
Ravissant Markandey
Ranch Hand
Posts: 41
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
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

 
Happiness is not a goal ... it's a by-product of a life well lived - Eleanor Roosevelt. Tiny ad:
the new thread boost feature: great for the advertiser and smooth for the coderanch user
https://coderanch.com/t/674455/Thread-Boost-feature
  • Post Reply Bookmark Topic Watch Topic
  • New Topic
Boost this thread!