Storedprocedures returns cursor

[jaya nair]

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]

check the driver documentation for the types in case for orcale driver there is OracleType class is there to specfiy the types

[jaya nair]

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]

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]

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