how to call a stored procedure which return cursor
posted 12 years ago
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