Parameters can be passed either to explicitly defined cursors or to a cursor FOR loop. Each time the cursor is executed, parameters are passed to the query and the active set is defined based on the parameters passed, as shown in the following program code:
