Oracle APEX Blogs - Jaydip Bosamiya - Oracle APEX Consultant

APEX Office Print (AOP) is a great document printing library for Oracle APEX. While using AOP to print IR or Chart regions into document, you may like to use "aop-region-as" attribute to inform AOP printing engine to print output in different formats. Following are the attribute values, you may set: client_svg:  This will create SVG object in the div. You may use it as {%region}. client_canvas:  This will create CANVAS object in the div. You may use it as {%region}. server_html:  This will put exact html of region inside a div. You may use it as {_region}. client_html:  This will put browser html of region inside a div. You may use it as {_region}. client_screenshot:  This will capture region screenshot rendered in client browser window. You may use it as {%region}. To use this tag, while you are setting regions to be printed into your AOP template, you provide static ID of that region. Along with that enter one of the following attribute into Cu...

Apex Office Print (AOP) is a great tool for document printing, document conversion and document merging. We have used AOP Converter API to merge pdf documents, and it works great. It was fast to implement and worked very well. We have observed during testing that we are hitting performance issue with large pdf files. I have used following apporach to overcome this. Following is the sample AOP API call where we were getting performance issue: l_blob_return := aop_api_pkg.plsql_call_to_aop(       p_data_type             => 'SQL',       p_data_source           => q'!select       'file1' as "filename",       cursor       (select            '1' as "dummy"        from dual       ) as "data"   from dual!',       p_template_type        ...

When your images are uploaded into WORKSPACE_IMAGES and you want to use that into AOP template, following can be a simple way to do it. Within you source SQL query, you will be able to get image base64 using following query. (SELECT APEX_WEB_SERVICE.BLOB2CLOBBASE64(FILE_CONTENT) FROM apex_workspace_static_files WHERE file_name = <your_image_file_name_with_extention>) as "my_ws_img" Now, you may refer this as a Inline SQL or CURSOR statement within Data Source SQL of AOP process. You may refer this column into AOP templates, as {%my_ws_img}. Hope that helps! Thanks, Jaydip Bosamiya jbosamiya@gmail.com

Apex Office Print is one of the popular tool for generating documents using Oracle APEX. While using AOP process type plugin, you will commonly see following error message. Error: SyntaxError: Unexpected token % in JSON at position 0 Above error has nothing to do with AOP settings or anything else. Following is simple solution: 1. Open Page properties and check the Advance > Reload on Submit setting. 2. Make sure it is "Always". Save the changes and check again. Hope this helps! Regards, Jaydip Bosamiya jbosamiya@gmail.com