The problem is on the SQL stored procedure end.

The cursor works exactly as expected IF the stored procedure returns a result set from a SELECT command.

It (the cursor) does NOT work if the stored procedure just returns a value