CREATE OR REPLACE PACKAGE varcharjoiner
IS
   TYPE t IS TABLE OF VARCHAR2 (32767);

   TYPE rec_s IS RECORD (
      s   VARCHAR2 (32767)
   );

   TYPE cur_rec_s IS REF CURSOR
      RETURN rec_s;

   /*EXAMPLE
   SELECT varcharjoiner.buildclobfromvarchar2cursor
                                  (CURSOR (SELECT   text
                                               FROM dba_source
                                              WHERE owner = 'ALDO'
                                                AND TYPE = 'PACKAGE BODY'
                                                AND NAME = 'PKG_ALL'
                                           ORDER BY line
                                          )
                                  ) clob_text
   FROM DUAL
   */
   FUNCTION buildclobfromvarchar2cursor (mc IN cur_rec_s)
      RETURN CLOB;

   /*SEE EXAMPLE1 */
   FUNCTION buildclobfromvarchar2curproc (tt IN t)
      RETURN CLOB;

   FUNCTION example1
      RETURN CLOB;
END varcharjoiner;