Clear_Buffer

Removes a buffer and releases the memory occupied by the buffer.

PROCEDURE Clear_Buffer (  
   buffer_ IN type_buffer_ )

Parameters

buffer_

Example

SQL> SET SERVEROUT ON SIZE 100000  
SQL> DECLARE  
        buffer_  Plsqlap_Buffer_API.type_buffer_;  
     BEGIN  
        ...  
        Plsqlap_Buffer_API.Clear_Buffer(buffer_);  
        ...  
     END;