• Post Reply
  • Bookmark Topic Watch Topic
  • New Topic

Storedprocedures returns cursor

 
jaya nair
Greenhorn
Posts: 9
  • Mark post as helpful
  • send pies
  • Quote
  • 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
 
Baiju Varugese
Ranch Hand
Posts: 74
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
check the driver documentation for the types in case for orcale driver there is OracleType class is there to specfiy the types
 
jaya nair
Greenhorn
Posts: 9
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
Hi

Im unable to find the Driver documentation. I even searched the microsoft website..
can u please tell me where can i find the API for
Microsoft JDBC Driver

Thanks for response
 
Sunil Dumpala
Greenhorn
Posts: 29
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
Please review the following link.

http://asktom.oracle.com/~tkyte/ResultSets/

I was working with JDBC on Oracle database. The above article was useful to me. I hope it would be helpful to you too.
 
jaya nair
Greenhorn
Posts: 9
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
Hi Sunil
Thanks for you response.
But im using SQLServer ..i need to know how to solve this when using SQLServer.
As im not able to find the Driver Documentation (Microsoft JDBC Driver for SQLServer).Please let me know where can i find the API for this driver.
Please any one help me reg this issue.Its very urgent
 
  • Post Reply
  • Bookmark Topic Watch Topic
  • New Topic