• Post Reply Bookmark Topic Watch Topic
  • New Topic
programming forums Java Mobile Certification Databases Caching Books Engineering Micro Controllers OS Languages Paradigms IDEs Build Tools Frameworks Application Servers Open Source This Site Careers Other Pie Elite all forums
this forum made possible by our volunteer staff, including ...
Marshals:
  • Campbell Ritchie
  • Jeanne Boyarsky
  • Ron McLeod
  • Paul Clapham
  • Liutauras Vilda
Sheriffs:
  • paul wheaton
  • Rob Spoor
  • Devaka Cooray
Saloon Keepers:
  • Stephan van Hulst
  • Tim Holloway
  • Carey Brown
  • Frits Walraven
  • Tim Moores
Bartenders:
  • Mikalai Zaikin

Retrieving the output parameter from the CallableStatement

 
Ranch Hand
Posts: 33
  • Mark post as helpful
  • send pies
    Number of slices to send:
    Optional 'thank-you' note:
  • 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.
 
Ranch Hand
Posts: 103
  • Mark post as helpful
  • send pies
    Number of slices to send:
    Optional 'thank-you' note:
  • 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
  • Mark post as helpful
  • send pies
    Number of slices to send:
    Optional 'thank-you' note:
  • 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
  • Mark post as helpful
  • send pies
    Number of slices to send:
    Optional 'thank-you' note:
  • Quote
  • Report post to moderator
Hi Andy!!
Have U got it.
Chandran..
 
Andy Skalkin
Ranch Hand
Posts: 33
  • Mark post as helpful
  • send pies
    Number of slices to send:
    Optional 'thank-you' note:
  • 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
  • Mark post as helpful
  • send pies
    Number of slices to send:
    Optional 'thank-you' note:
  • 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
  • Mark post as helpful
  • send pies
    Number of slices to send:
    Optional 'thank-you' note:
  • 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.
 
With a little knowledge, a cast iron skillet is non-stick and lasts a lifetime.
reply
    Bookmark Topic Watch Topic
  • New Topic