Apex Office Print (AOP) - How to use workspace images into AOP template

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!

Jaydip Bosamiya


My photo
Jaydip Bosamiya
I am Oracle APEX Consultant, Blogger and Integrator. All-rounder in building small, medium and enterprise applications. Extensive knowledge in various area of web-driven applications in Back-end (PL/SQL, SQL, Java), Front-end (Oracle APEX, HTML, JavaScript, CSS, jQuery, OracleJET, ReactJS), RESTful APIs, Third-party library integrations (Apex Office Print (AOP), Payment Gateways, Syncfusion, HighCharts) and APEX Plugins (HighChart, StarRating)

Popular posts from this blog

Oracle APEX - Interactive Report - Scrollbars on Top

How to create your own customized nested report regions using jQuery

Make your RESTful APIs Secured with OAuth2 - Basic, Simple and Easy Steps