wood burning stoves 2.0*
The moose likes JDBC and the fly likes Retrieving the output parameter from the CallableStatement Big Moose Saloon
  Search | Java FAQ | Recent Topics | Flagged Topics | Hot Topics | Zero Replies
Register / Login
JavaRanch » Java Forums » Databases » JDBC
Bookmark "Retrieving the output parameter from the CallableStatement" Watch "Retrieving the output parameter from the CallableStatement" New topic
Author

Retrieving the output parameter from the CallableStatement

Andy Skalkin
Ranch Hand

Joined: Apr 05, 2001
Posts: 33
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

Joined: May 04, 2001
Posts: 103
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


chandran..
Andy Skalkin
Ranch Hand

Joined: Apr 05, 2001
Posts: 33
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

Joined: May 04, 2001
Posts: 103
Hi Andy!!
Have U got it.
Chandran..
Andy Skalkin
Ranch Hand

Joined: Apr 05, 2001
Posts: 33
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

Joined: May 04, 2001
Posts: 103
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

Joined: Apr 05, 2001
Posts: 33
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.
 
subject: Retrieving the output parameter from the CallableStatement