Oracle APEX Developer Blog

About the Everyday Routine of a Oracle APEX Developer

  • Oracle APEX App Import Error: ORA-01403 no data found

    The other day I came across a bug in Oracle APEX 21.2.10.This error occurred during the app import: After some troubleshooting, we found out that it was due to ACL role assignments that are defined in the APEX App Shared Components. These are stored in the metadata and are not transferred via App export and…

  • Remove HTML Content from String with Oracle APEX 22.2

    If you want to remove all HTML Content from a String with Oracle there is now a great function available in Oracle APEX 22.2! Before that you had to use something like regexp_replace to remove any HTML Tags from a string. Check out the APEX Documentation for more Details: https://docs.oracle.com/en/database/oracle/apex/22.2/aeapi/STRIPHTML-Function-Signature-1.html#GUID-347F8DAD-5CC4-444C-A2C0-B102D1CC95FD Imagine you have a Column…

  • Create GET-Resource Handler using PL/SQL Cursor in Oracle APEX RESTful Services

    Sometimes you want to provide Data as REST Services from Oracle APEX. This may be an easy task if you need to publish one Table/View directly. But maybe you have some older PL/SQL logic with cursors and more that needs to be published as REST. In one Project we had to migrate an CSV-Export to…

  • Get BLOB file size with automatic meaningful units

    Just a quick reminder. Because this is not documented in the current API Docs at https://apex.oracle.com/api (as of Version 22.2). If you want to display the file size of BLOB in Oracle APEX you can make use of the function APEX_UTIL.filesize_mask. In Combination with dbms_lob.getlength it is easy to display any file size and no…