Breadcrumbs

Give it a try

Intro

This implementation is using a custom PL/SQL package, UC_PDF_REGION_PRO_CUSTOM_PKG, to process and store the documents in an APEX collection.

Place the following in the Initialization PL/SQL Code: 

uc_pdf_region_pro.g_doc_getfileinfo := 'uc_pdf_region_pro_custom_pkg.uc_pdf_region_pro_collection_getfileinfo';
uc_pdf_region_pro.g_doc_create      := 'uc_pdf_region_pro_custom_pkg.uc_pdf_region_pro_collection_create';
uc_pdf_region_pro.g_doc_update      := 'uc_pdf_region_pro_custom_pkg.uc_pdf_region_pro_collection_update';

The definitions of the procedures are: 

procedure uc_pdf_region_pro_collection_create(
    p_application_id          in number,   
    p_page_id                 in number,
    p_session_id              in number,
    p_user_id                 in varchar2,        
    p_file_id                 out varchar2,
    p_file_content            in blob,
    p_file_filename           in out varchar2,
    p_file_mime_type          in varchar2,
    p_file_last_update_date   in out timestamp,
    p_file_version            in out number,
    p_file_blob_owner         in out varchar2
  );
  
  procedure uc_pdf_region_pro_collection_update(
    p_application_id          in number,   
    p_page_id                 in number,
    p_session_id              in number,
    p_user_id                 in varchar2,    
    p_file_id                 in varchar2,
    p_file_content            in blob,
    p_file_filename           in varchar2,
    p_file_mime_type          in varchar2,
    p_file_last_update_date   in out timestamp,
    p_file_version            in out number,
    p_file_blob_owner         in varchar2
  );
    
  procedure uc_pdf_region_pro_collection_getfileinfo(
    p_application_id          in number,   
    p_page_id                 in number,
    p_session_id              in number,
    p_user_id                 in varchar2,    
    p_file_id                 in  varchar2,
    p_out_content             out BLOB,
    p_out_filename            out varchar2,
    p_out_mime_type           out varchar2,
    p_out_last_update_date    out timestamp,
    p_out_version             out varchar2,
    p_out_blob_owner          out varchar2
  );

Demo