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