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! Thanks, Jaydip Bosamiya jbosamiya@gmail.com
