Disadvantages of cursors

• Uses more resources because each time you fetch a row from the cursor, it results in a network roundtrip.
• There are restrictions on the SELECT statements that can be used. 
• Because of the round trips, performance and speed is slow.