Win a copy of The Little Book of Impediments (e-book only) this week in the Agile and Other Processes forum!
    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
Saloon Keeper
Posts: 15630
46
Android IntelliJ IDE Java Scala Spring
 
Jeanne Boyarsky
author & internet detective
Marshal
Posts: 35279
384
Eclipse IDE Java VI Editor
 
    Bookmark Topic Watch Topic
  • New Topic