Enterprise Edition Home | Express Edition Home | Previous Page | Next Page   SQL Statements > CLOSE >

Closing a Collection Cursor (IDS)

You can declare both select and insert cursors on collection variables. Such cursors are called collection cursors. Use the CLOSE statement to deallocate resources that have been allocated for the collection cursor.

For more information on how to use a collection cursor, see Fetching from a Collection Cursor (IDS) and Inserting into a Collection Cursor (IDS).

Enterprise Edition Home | Express Edition Home | [ Top of Page | Previous Page | Next Page | Contents | Index ]