DBMS_SQL , 16 of 20

CLOSE_CURSOR Procedure

This procedure closes a given cursor.

Syntax

DBMS_SQL.CLOSE_CURSOR (
   c    IN OUT INTEGER);

Pragmas

pragma restrict_references(close_cursor,RNDS,WNDS);

Parameters



Table 62-18  CLOSE_CURSOR Procedure Parameters 
 





Parameter 


Mode 


Description 


    
c
     
    
IN
     



ID number of the cursor that you want to close. 

    
c
     
    
OUT
     



Cursor is set to null. 


After you call CLOSE_CURSOR, the memory allocated to the cursor is released and you can no longer fetch from that cursor.