Using Scrollable Cursors

Usage information for scrollable cursors.

  • If you do specify insensitive or semi_sensitive when you execute declare cursor, the default sensitivity is implicit, so that the cursor’s sensitivity depends on the query plan chosen by the optimizer. If the query plan has any worktable created, the cursor becomes insensitive.

  • If you specify the cursor’s sensitivity to be semisensitive, sensitivity also depends on the query plan.

  • If you specify insensitive, the cursor is read_only. You cannot use a for update clause in a cursor declaration.

  • If you do not specify the cursor’s scrollability, no scroll is implied.

  • All scrollable cursors are read-only. You cannot use a for update clause in a cursor declaration.