TEMP space usage increases with usage of FETCH <<cursor>> BULK COLLECT INTO <<collection>> LIMIT <<l

 Hi,

I am currently facing an issue with the usage of the FETCH ... BULK COLLECT INTO ... LIMIT statement. This is the code snippet that is being executed.

Note - TYPE t_extract_tab IS TABLE OF VARCHAR2(4001);

PROCEDURE output_extract
            (
               p_extract_refcur IN  SYS_REFCURSOR,
               p_header  IN  VARCHAR2,
               x_return_code  OUT NUMBER,
               x_return_msg   OUT VARCHAR2
            )
IS

   l_proc_name        VARCHAR2(240):='output_extract';

   rExtracts_tab      t_extract_tab:=t_extract_tab(); 

BEGIN

   -----------------------
   /* Output Header */
   -----------------------
   fnd_file.put_line(fnd_file.output, p_header);

   ---------------------------
   /* Output Detail Records */
   ---------------------------
   LOOP

      -----------------------------------
      /* Fetch from balance temp table */