APEX Office PrintTemplate-based printing and document generation for APEX
APEX Media ExtensionImage processing for the Oracle Database
APEX Office EditOffice document editing for APEX
Plug-ins ProProfessional APEX plug-ins built and maintained by our team
Cloud Office PrintTemplate-based printing and document generation for any technology
APEX Project EyeQuality assurance & productivity tool for APEX developers
APEX Message ServiceReal-Time communication in APEX
dbLinterBoost database quality with automated code reviews
APEX Document ManagementAPEX-based enterprise document management platform
UC AIFreeFree, open-source PL/SQL SDK for AI in the Oracle Database
United Codes Blog
Founder and co-CEO of United Codes. Passionate about bringing ideas to life with code, and about Oracle APEX, the Oracle Database and AI-assisted development, which he writes about on dgielis.com.
The October 2026 Critical Patch Update fixes a 9.8 Oracle APEX vulnerability that needs no login. With AI finding bugs and writing exploits in minutes, staying current is the only real defense. How to check your versions and which patch level you need.
Dimitri Gielis · · 6 min read
Give every ticket, and every AI agent, its own Oracle Database in seconds: a snapshot copy of a golden PDB with its own schema, data and Oracle APEX workspace, with SQL or over ORDS REST.
Dimitri Gielis · · 6 min read
Writing the requirements for my World Cup 2026 app by voice, with Claude and ChatGPT reviewing each other: six rounds of refinement, and features I would never have thought of alone.
Dimitri Gielis · · 4 min read
The setup I use to build Oracle APEX apps with AI agents: VS Code, Claude Code and Codex, skills, SQLcl, Git, and a local Oracle Database and Oracle APEX in Docker. Step by step, so you can reproduce it.
Dimitri Gielis · · 6 min read
AI can generate a working app in minutes, but would you run it as enterprise software? Why the Oracle APEX developer becomes a designer, orchestrator and validator.
Dimitri Gielis · · 4 min read
From a bootstrapped dream to a shared future, built on people, passion, and purpose.
Dimitri Gielis · · 3 min read
We’ve listened to you, the Oracle APEX community… you love the FOS plug-ins, and so do we! So I’m thrilled to announce we’ve adopted the FOS plug-ins as part of our Plug-ins Pro Community Plug-ins offering. We will continue to enhance and support them and are dedicated to serving the Oracle APEX community.
Dimitri Gielis · · 2 min read
APE is a powerhouse of tools that helps any Oracle APEX developer and project manager. For me, APEX Project Eye is for Oracle APEX, what Enterprise Manager is for the Oracle Database. APE is the most advanced tool to give you insight into your Oracle APEX applications, from how it was developed to how it is being used.
Dimitri Gielis · · 3 min read
So I thought to create an example and see what it would take to get the Saved Report name in the document. I went into the AOP Sample Application and clicked on the example where there are Saved Reports for an Interactive Report. The way I understand the question is how to use the name of the saved report, in our case, "3. Highlight", in the export to Excel or PDF.
Dimitri Gielis · · 2 min read
In almost every Oracle APEX application, I create a Report with Form to edit the data. From time to time, I get the question of how first to save the record and next print or download the document.
Dimitri Gielis · · 1 min read
Sometimes you expect to see some data in your Oracle APEX application, and it's not there... in this post, I will describe one use case I see more often and how to solve it.
Dimitri Gielis · · 2 min read
Today there was a question on how to export data from the Oracle Database and Oracle APEX into one Excel file with multiple sheets. Each sheet contains data from a different table. With APEX Office Print, it's a matter of a few minutes to fulfill this request.
Dimitri Gielis · · 4 min read
An AOP customer wrote us that when opening a PDF in a Modal Dialog, the spinning icon didn't disappear automatically anymore in Oracle APEX 21.1, whereas it did before.
Dimitri Gielis · · 1 min read
This post is part of Dimitri's series: My spin on the new Oracle APEX Application Development Service. This post will take you through a 3 step process on how to setup the APEX Office Print (AOP) Server using the Oracle Cloud APEX Service.
Dimitri Gielis · · 4 min read
Get a bit of background on our Rich Text Editor plug-in and see how you can use it in your own applications.
Dimitri Gielis · · 5 min read
One of the most loved features of APEX Office Print (AOP) is the ability to export an Interactive Report or Grid exactly as you see it on the screen to Excel and PDF. AOP takes into account highlighting, filters, and more as defined by the end-user. This feature has been available since AOP 1.5 (2015) on APEX 5.0 and any higher version of APEX.
Dimitri Gielis · · 6 min read
In this blog post, I want to cover PDF Forms. PDF Forms have been around for a long time. My guess is that everybody has had to fill in at least one PDF Form already. An example we as a company have to fill in a lot is the W-8BEN form, another example is Form 941 Federal Tax Return.
Dimitri Gielis · · 2 min read
In many Oracle Application Express projects, there's a requirement that people can upload files. Typically the end-users want the ability to drag and drop images, PDFs, or other file types in their application. For example, if you use APEX Office Print, you might have added in your application the ability for end-users to upload their own templates, which typically are docx, xlsx, pptx, html and text files.
Dimitri Gielis · · 6 min read
Charts and visualizations become very important when talking about data. Businesses are using these visualizations to make an appealing story. You will find many tips and tricks on the internet when you search for Data Storytelling. One of the most important tips is to use the right chart for your data.
Dimitri Gielis · · 5 min read
In this blog post, I want to highlight another Interactive Grid plug-in we've built: the United Codes Interactive Grid Download File Plug-in. When you buy any of the United Codes products, when you go to your Account on the website, you can click on View Invoices and have the ability to download them. Those invoices were created with APEX Office Print (AOP) and stored in a BLOB column of a table.
Dimitri Gielis · · 4 min read
I don't know about you, but I had a love/hate relationship with Interactive Grids in Oracle APEX. I love it because it's really powerful and very useful, and fast to insert, update, and delete multiple records at once. It was also the basis of many new things in APEX linked to modern web development.
Dimitri Gielis · · 5 min read
Creating a form with some items in Oracle APEX is fast and easy... Here's an example of a sign-up form I created in my APEX app, heavily inspired on the Github sign-up form.
Dimitri Gielis · · 7 min read
In a previous post, I gave a bit more background on Plug-ins Pro. In this post, I will guide you on how to get started on your FREE trial. I plan to blog more about the specific plug-ins and will update this post with the links to the specific plug-in posts. Let's get started!
Dimitri Gielis · · 4 min read
Since 2004 I've used Oracle Application Express (APEX), and I just love it. With every new release of APEX, things become easier, and new features get added, going from new item types like switches to rich components like charts. But the web is moving fast, and customers want more and more, which means you need to go outside of what APEX provides.
Dimitri Gielis · · 4 min read
Last Thursday we gave a new look to our products APEX Office Print (AOP) and APEX Media Extension (AME). Not only did they get a new logo, but the whole website and portal were also put in a more modern, minimalistic look.
Dimitri Gielis · · 4 min read
One of the new features in Oracle Application Express (APEX) 20.1 is the integration with APEX Office Print (AOP). In this blog post, I want to cover what this integration means and how you can set up and use AOP in APEX 20.1.
Dimitri Gielis · · 4 min read
I'm extremely proud to bring our second product to the Oracle and APEX community. With our first product, APEX Office Print (AOP), we wanted to make the Printing and Exporting of documents easy. With APEX Media Extension (AME) we want to make the processing of media easy for any Oracle database and Oracle APEX developer!!
Dimitri Gielis · · 2 min read
As more people asked the question of how to print to a local printer from Oracle APEX, I will cover 3 options in this post. All options make use of some features of APEX Office Print (AOP).
Dimitri Gielis · · 2 min read
These days Oracle Application Express (APEX) is being used more and more in "local" applications like a bar, a restaurant, a power station, etc. On many occasions, they also have the requirement to print something to a local printer.
Dimitri Gielis · · 2 min read
In this blog post, I will do a step-by-step guide on how I believe you will be most performant building your templates and using them in AOP.
Dimitri Gielis · · 5 min read
If you are reading this blog post you are probably searching for an alternative for the deprecated multimedia (or intermedia) feature of the Oracle Database... and you are in the right post as APEX Media Extension is that replacement!
Dimitri Gielis · · 2 min read
I want to show you how to get started with the popular printing and reporting engine, APEX Office Print (AOP). The AOP software makes it super easy to export your data into a nice-looking PDF, a custom Excel file, a fancy Powerpoint or other output formats of your choice, just the way you want it.
Dimitri Gielis · · 6 min read
Our dream is that every developer can use AOP, that is why in AOP 18.1 (released September 2018) we made a Free Cloud Tier. With AOP 19.1 we go one step further... from now on you can run AOP in Developer Mode, which means you can call our cloud as much as you like in this mode.
Dimitri Gielis · · 4 min read
