Closing Cursor Variables:

Cursor variables are closed just such as static cursors using the CLOSE statement. That frees the resources used for the query. Cursor variable does not necessarily free the storage for the cursor variable itself. Storage for the variable is freed when the variable goes out of scope. This is illegal to close a cursor or cursor variable which is already closed. The Cursor variables can be closed on either the client or the server. Within preceding program, the Cursor is opened on the server (by the embedded anonymous block) and fetched from and closed back on the client. Because the cursor variable is defined as a host variable, that is unconstrained.