Win a copy of Soft Skills: The software developer's life manual this week in the Jobs Discussion forum!
  • Post Reply
  • Bookmark Topic Watch Topic
  • New Topic

Retrieving the output parameter from the CallableStatement

 
Andy Skalkin
Ranch Hand
Posts: 33
  • 0
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
Can someone help me ? I'm tired of trying to retrieve the output parameter from the sp...
I'm getting NumberFormatException when I call getInt(3) method.
Here is my code

Here is my sp written in T-SQL; I tested it - works fine.
 
Raajesh Chandran
Ranch Hand
Posts: 103
  • 0
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
Hi!!
I'm having the same problem too.Two days before only I placed my doubts here.Let try .I will inform U if I got it.One more thing what version U r using (Oracle and JDK).I think this is bcoz of driver problems.
regards,
chandran
 
Andy Skalkin
Ranch Hand
Posts: 33
  • 0
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
Hi Raajesh,
I saw your post and I will let you know if I succeed.
I'm using MSSQL2000 with jdbc-odbc bridge and JDK 1.3
Good luck !
Andy.
 
Raajesh Chandran
Ranch Hand
Posts: 103
  • 0
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
Hi Andy!!
Have U got it.
Chandran..
 
Andy Skalkin
Ranch Hand
Posts: 33
  • 0
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
No I didn't.
Actually I switched to another task for a while. And I will let you know if I succeed.
Regards,
Andy
 
Raajesh Chandran
Ranch Hand
Posts: 103
  • 0
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
Hi Andy!
version is the problem.I installed Oracle8i instead of Oracle8.
now its work fine for me.so,try to install the latest version of SQLSERVER otherwise try in Oracle8i.
BestWishes,
Chandran
 
Andy Skalkin
Ranch Hand
Posts: 33
  • 0
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
Good for you
I'm using MS SQL2000 and don't want to mirgate to Oracle. I will try to find another non-ODBC driver. However this is not high priority question
Regards,
Andy.
 
It is sorta covered in the JavaRanch Style Guide.
  • Post Reply
  • Bookmark Topic Watch Topic
  • New Topic