PL stored programs support cursors, and their syntax is the same as embedded SQL.
Cursor declarations must appear before handler declarations and after variable and condition declarations. Cursors have the following properties:
Insensitivity: The server may or may not replicate its result set.
Read-only: cannot be updated.
Non-scrollable: It can only traverse in one direction and cannot skip rows.