Wrapper for APEX_ZIP.ADD_FILE for CLOB content

apex_zip_add_file_clob.prc

 CREATE OR REPLACE PROCEDURE zip_add_file_clob(p_zipped_blob IN OUT NOCOPY BLOB,
                                               p_name        IN VARCHAR2,
                                               p_content     IN CLOB) AS
   --
   l_tmp         BLOB;
   l_dest_offset INTEGER := 1;
   l_src_offset  INTEGER := 1;
   l_warning     INTEGER;
   l_lang_ctx    INTEGER := dbms_lob.default_lang_ctx;
   --
 BEGIN
   dbms_lob.createtemporary(l_tmp,
                            TRUE);
   --
   dbms_lob.converttoblob(l_tmp,
                          p_content,
                          dbms_lob.lobmaxsize,
                          l_dest_offset,
                          l_src_offset,
                          nls_charset_id('AL32UTF8'),
                          l_lang_ctx,
                          l_warning);
   --
   apex_zip.add_file(p_zipped_blob,
                     p_name,
                     l_tmp);
   --
   dbms_lob.freetemporary(l_tmp);
   --
 END zip_add_file_clob;