Many disadvantages are in Cursor which is defined here :
> Occurs network round trip because Each time we fetch a row from the cursor,; where as a normal SELECT query makes only one round trip, however large the resultset is.
> It is very costly because they require more resources and temporary storage. Further, there are restrictions on the SELECT statements that can be used with some types of cursors.
> Another situation in which developers tend to use cursors: we need to call a stored procedure when a column in a particular row meets certain condition. We don\'t have to use cursors for this. This can be achieved using WHILE loop, as long as there is a unique key to identify each row.