Hi


I have a Stored Procedure with Cursor, I open the cursor out while as:

open cr_Agenda
fetch next from cr_Agenda into @Whr_ini, @Whr_fim,@wlocal,@wnom_loc,@Wccu

while (@@FETCH_STATUS = 0)
begin
<statements>
fetch next from cr_Agenda into @Whr_ini, @Whr_fim,@wlocal,@wnom_loc,@wccu
end
When it read the last row +1 , Where Is wrong ?

Server: Msg 16915, Level 16, State 1, Line -1074292529
A cursor with the name 'cr_Agenda' already exists.