Many times your APEX Work-space accounts gets locked on few wrong attempts or any other reasons – This normally requires you to contact administrator and unlock your locked user. This is sometimes very time consuming process and needs to wait for someone for such a small stuff. So, even if your APEX accounts gets locked …

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 …