You can declare the following types of cursors in a DECLARE CURSOR statement:
- Dynamic
- Macro
- Request
- Selection
- Stored procedure Stored procedures only support stored procedure-type cursors.
The following types refer to ways you can use a cursor to manipulate data:
- Positioned (updatable)
- Non-positioned (read only)
Both types are supported in embedded SQL and stored procedures.