February 7, 2019 APEX 1 Comment

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

, ,
Written by Jaydip Bosamiya