File Upload Configuration & Display in Interactive Report – Oracle APEX

 

3. Prerequisites

  • Oracle APEX access (Developer role)
  • Database table with BLOB column (e.g., DOCUMENTS)
  • Required columns:
    1. DOCUMENTS (BLOB)
    2. MIME_TYPE (VARCHAR2)
    3. DOCUMENT_NAME (VARCHAR2)
    4. CHAR_SET (VARCHAR2)
    5. Primary Key (e.g., MAINTENANCE_ID)


4. Procedure

Click Save & Run

 

4.3 File Upload Item Configuration




4.3.1 Configure Storage Attributes

   Attribute

      Value

BLOB Column

  Bill

MIME Type Column

  MIME_TYPE

Filename Column

 Bill_NAME

Character Set Column

  CHAR_SET

 

4.3.2 Set File Metadata Columns

  • Copy from database and map:

Database Column

         APEX Setting

     MIME_TYPE

         MIME Type Column

     DOCUMENT_NAME

         Filename Column

      CHAR_SET

         Character Set Column

 

4.3.3 Define File Types

  • Go to Storage → File Types
  • Set allowed types:

                                *.pdf, *.jpg


 

4.4 Download BLOB Configuration

  • Go to:
    Documents Item → Identification

Set the following:

Property

                 Value

Type

          Download BLOB



BLOB Column

         BILL

Primary Key Column

          MAINTENANCE_ID

MIME Type Column

          MIME_TYPE

Filename Column

          BILL_NAME

Character Set Column

          CHAR_SET


4.5 Testing

  1. Upload a file from the form
  2. Save the record
  3. Open Interactive Report
  4. Verify:
    1. File size appears (via DBMS_LOB.GETLENGTH)
    2. File download works correctly
    3. Correct filename and MIME type.


Comments

Post a Comment

Popular posts from this blog

  Advantages and Disadvantages of Subqueries in SQL In SQL, writing clean and efficient queries is something every developer aims for. One feature that often helps with this is the subquery . It’s simple, powerful, and very useful in many situations. But like any tool, it has its strengths and its limitations.   What is a Subquery? A subquery is just a query written inside another query. Think of it like asking one question to help answer another. For example: SELECT name FROM employees WHERE salary > (SELECT AVG(salary) FROM employees); Here, the inner query finds the average salary, and the outer query uses that result to find employees who earn more than average. Simple and effective. Advantages of Subqueries 1. Makes Complex Problems Easier Instead of solving everything in one big query, subqueries let you break the problem into smaller parts. This makes your logic easier to think about and implement. 2. Cleaner and More Understandable In many cas...
Read more
  Disadvantages of PL/SQL Packages You Should Be Aware Of PL/SQL packages are a core part of Oracle database development. Most Oracle developers rely on them to organize code, improve performance, and make logic reusable across applications. In many enterprise systems, packages hold the main business logic and help keep database programs structured and manageable. However, like any powerful tool, PL/SQL packages are not perfect for every situation. While they offer many advantages, they also come with a few limitations that developers and architects should keep in mind when designing database solutions. Based on real development experience, here are some disadvantages of PL/SQL packages that are worth understanding before using them extensively. 1. Design Complexity Can Increase Quickly When used properly, packages help organize related procedures and functions. But as applications grow over time, packages can also become very large and difficult to manage . If too much...
Read more
  Advantages & Disadvantages of Oracle APEX In today’s fast-moving tech world, everyone wants to build applications faster without compromising on security and performance. That’s where Oracle APEX (Application Express) comes into the picture. Whether you’re just starting your journey or already working in development, knowing where APEX shines—and where it doesn’t—can help you make better decisions. What is Oracle APEX? Oracle APEX is a low-code platform that helps you create web applications using SQL and PL/SQL. The interesting part? Everything runs directly inside the Oracle Database. That means your app and your data stay close together—making it secure, fast, and reliable, especially for data-heavy applications. Advantages of Oracle APEX 1. Build Applications Quickly One of the biggest benefits of APEX is speed. You don’t have to start from scratch—there are ready-made components, templates, and wizards that make development much faster.You can go from i...
Read more