Again an update caused this this issue. I had dropped a few columns from a table here and there. I have updated the necessary procedure populates that table. Beautifully, I executed the java code, loading that table with out changing that. varchar is assigned to date and viceversa. I hit with this issue.
PLS-00306 Error: Wrong number of types of arguments in call to procedure So, no way, I corrected them all. and it is working fine 🙂