Bookmark Topic Watch Topic
  • New Topic

how to call a stored procedure which return cursor

 
jaya nair
Greenhorn
Posts: 9
  • Mark post as helpful
  • send pies
  • Report post to moderator
Hi All,

Im using Microsoft JDBC Driver for MSSQL.
I have a Stored Procedure which returns CURSOR
How should i handle this cursor in jdbc prg.
Im using this to register out parameter
call.registerOutParameter(1, java.sql.Types.OTHER);
But im getting an error saying
"The specified SQL type is not supported by this driver"
Which type should i use for a cursor?

can anyone help me regarding this issue. this is very urgent for me.
Thanks in advance
 
Jesper de Jong
Java Cowboy
Sheriff
Posts: 15767
74
Android IntelliJ IDE Java Scala Spring
 
Jeanne Boyarsky
author & internet detective
Sheriff
Posts: 36032
432
Eclipse IDE Java VI Editor
 
Gravity is a harsh mistress. But this tiny ad is pretty easy to deal with:
the new thread boost feature: great for the advertiser and smooth for the coderanch user
https://coderanch.com/t/674455/Thread-Boost-feature
    Bookmark Topic Watch Topic
  • New Topic
Boost this thread!