<div>
Could you post your code? I think you are missing output key word.
</div>


Could you post your code? I think you are missing output key word.

<div>
<div class="content wysiwyg-content">
we are using a cursor varying type as an output parm of one stored proc. when assigning the returned cursor for this Stored proc to a cursor variable in the calling stored proc and trying to fetch through it we have the following error:<br />
<br />
Server: Msg 16958, Level 16, State 1, Line 20<br />
Could not complete cursor operation because the set options have changed since the cursor was declared.<br />
<br />
can any body help!<br />
thanks in advance
</div>
</div>


we are using a cursor varying type as an output parm of one stored proc. when assigning the returned cursor for this Stored proc to a cursor variable in the calling stored proc and trying to fetch through it we have the following error:

Server: Msg 16958, Level 16, State 1, Line 20
Could not complete cursor operation because the set options have changed since the cursor was declared.

can any body help!
thanks in advance

Problem With Cursors - Error 16958

Microsoft SQL Server is a suite of relational database management system (RDBMS) products providing multi-user database access functionality.SQL Server is available in multiple versions, typically identified by release year, and versions are subdivided into editions to distinguish between product functionality. Component services include integration (SSIS), reporting (SSRS), analysis (SSAS), data quality, master data, T-SQL and performance tuning.