otro

DECLARE   l_lob      BLOB;   l_length   NUMBER;   l_mimetype VARCHAR2(2000);   l_filename VARCHAR2(2000); BEGIN --   SELECT DOCUMENT_DATA,     MIME_TYPE ,     NAME_FILE   INTO l_lob,     l_mimetype,     l_filename   FROM TB_DOCUMENT_TYPE   WHERE NUMBER_ID = nvl(:APP_NUMBER_ID_EMPLOYEE,43)   AND LOV_DOCUMENT_TYPE IN (                                 select                                      code                                 from                                  tb_lov_detail                                 where master = (select MASTER_ID from tb_lov_master where CODE = 'TIPOS_ARCHIVO')                             );   --   l_length := DBMS_LOB.getlength(l_lob);   --   htp.flush;   htp.init;   --   owa_util.mime_header(nvl(l_mimetype,'application/octet'), FALSE);     htp.p('Content-length:' || l_length);   htp.p('Content-Disposition:inline;filename="' || l_filename || '"');   --   -- close the headers   owa_util.http_header_close;   --   -- download the BLOB   wpg_docload.download_file(l_lob); END;