17.11. Cursor definition operator over dynamically prepared select statement

  <allocate cursor statement> :: =
    ALLOCATE <extended cursor name> [INSENSITIVE] [SCROLL]
    CURSOR FOR <extended statement name>
 <extended cursor name> :: =
  (<scope option>] <simple value specification> 

Comment:

Cursors defined using the ALLOCATE CURSOR statement are actually created when the statement is executed and destroyed when the DEALLOCATE PREPARE statement is executed or when a transaction is completed. In this statement, the names of the cursor and prepared SQL statement can be specified not only in literal form, but also through variables. <scope option> refers to the scope of names: within the current module or within the current session.