Breadcrumbs

Give it a try

Intro

PDF Region Pro supports callbacks, which you may want to use to track which files are opened or stored.

This example utilizes PL/SQL callbacks to log the current document action (create, load, read, update, save as, or rename) in an APEX collection with a short description of the action.

In order to enable callbacks, Initialization PL/SQL Code attribute must be fed with the following example configuration 

UC_PDF_REGION_PRO.g_doc_callback_read   := 'uc_pdf_region_pro_callback_pkg.uc_pdf_region_pro_callback_read';
UC_PDF_REGION_PRO.g_doc_callback_update := 'uc_pdf_region_pro_callback_pkg.uc_pdf_region_pro_callback_update';
UC_PDF_REGION_PRO.g_doc_callback_create := 'uc_pdf_region_pro_callback_pkg.uc_pdf_region_pro_callback_create';

The callback procedures have the following specifications: 

  procedure uc_pdf_region_pro_callback_collection_read(
    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 timestamp,
    p_file_version                  in number,
    p_file_blob_owner               in varchar2
  );

  procedure uc_pdf_region_pro_callback_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 timestamp,
    p_file_version                  in number,
    p_file_blob_owner               in varchar2
  );

  procedure uc_pdf_region_pro_callback_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                       in varchar2,
    p_file_content                  in blob,
    p_file_filename                 in varchar2,
    p_file_mime_type                in varchar2,
    p_file_last_update_date         in timestamp,
    p_file_version                  in number,
    p_file_blob_owner               in varchar2
  );

Check also

PDF Region Pro gives you complete control over document handling when using Custom PL/SQL as your Source. Check the examples for more custom PL/SQL implementations.

Plug-in