OracleType.Cursor,请问OleDb类型的Cursor怎么定义？

[cc_program]

OracleType.Cursor,请问OleDb类型的Cursor怎么定义？
调用Oracle存储过程，返回多个数据集时，总是取不到数，想把参数OracleType.Cursor改称OleDb类型的试试，请教怎么定义阿、

[godgreat]

沙发

[godgreat]

DECLARE @Cursor CURSOR

SET @Cursor = CURSOR SCROLL DYNAMIC
FOR
select ... from yourtable where ...

OPEN @Cursor

FETCH NEXT FROM @Cursor
...

CLOSE @Cursor
DEALLOCATE @Cursor