In this section, we'll learn how to display images in our Oracle APEX application without relying on a page item. This method is perfect for situations where we need to show an image directly from a database table column, a file, or a URL without first loading it into a specific page item. We'll cover how to achieve this using a dynamic action and a PL/SQL procedure, making our application more efficient and flexible. By the end of this tutorial, we'll be able to display images dynamically, improving the user experience and reducing page load times. This technique is useful for reports, dashboards, and custom user interfaces where a static page item isn't the best solution. You can vind a visual solution from here. STEP 1: Create a blank page. STEP 2: Create a region and set it properties like- Name: Emp Type: ...
In this section, we'll learn how to work with CLOB (Character Large Object) data in Oracle APEX. We'll walk through a practical example of converting plain text into a PDF file using JavaScript and then saving that PDF into the Oracle database as a CLOB. This is especially useful for applications that need to store generated reports, dynamic content, or user input in document format without using BLOB storage. To implement this, we need to follow the below steps. For a visual assistance, you can find a tutorial from here . STEP 1- Create a blank page with neccessary items : i. Create a region and set it properties as like below- ii. Create page items under that region P34_REPORT_ID TYPE: Text Field Template: O...