Bookmark Topic Watch Topic
  • New Topic

how to call a stored procedure which return cursor  RSS feed

jaya nair
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
Posts: 16044
Android IntelliJ IDE Java Scala Spring
Jeanne Boyarsky
author & internet detective
Posts: 37393
Eclipse IDE Java VI Editor
Don't get me started about those stupid light bulbs.
    Bookmark Topic Watch Topic
  • New Topic
Boost this thread!