Here is something new and interesting work-around I found out while working on validating apex authorization scheme using my custom pl/sql function. So, initially I used APEX_AUTHORIZATION.IS_AUTHORIZED function to evaluate my apex authorization scheme. But, I found a limitation with the use of is_authorized function. When my custom function refereed in SQL query it will end …

With apex 18 Universal theme, we have got few Card templates. It re-presents the information in Card format. Click here to see few examples of different types of Card. You can find card template in List Templates and Classic Report Templates. Objective of this blog is, how we can further enhance existing Card template such …

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 …

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. …