Making File Upload required in Oracle APEXMaking the File Upload a required field is difficult with APEX 24.1 or earlier. In this post, I will show you the solution I use until Oracle APEX's native behavior improves. The definition of my table: create table xfile ( id number ge...Jul 24, 2024·4 min read
ORDS - SQL Developer Web: Fix Invalid credentialsI had a weird issue with some Oracle database users I wanted to connect to in SQL Developer Web. When I tried to log in at https://hostname/ords/sql-developer, I received the error: Invalid credentials: If your ORDS schema alias is different from you...Nov 22, 2023·2 min read
A story about Joel and APEX Office Print (AOP) #JoelKallmanDaySince this is the special Joel Kallman day, I thought to share a story about how document generation with AOP started at Oracle's internal APEX environment. Today it might be normal for people to use APEX Office Print (AOP) to do their document gener...Oct 11, 2023·2 min read
Compare 2 Oracle APEX pagesI wanted to know if a page was the same within the same application. Two (+1 in Oracle APEX 22.1+) features in Oracle APEX help to compare pages, which you find under the tools menu: Checksum and Export: The checksum will show the checksum of the pa...Aug 15, 2023·2 min read
The application alias "X" can not be converted to a unique application ID.You get this error when two or more Oracle APEX applications have the same alias. When you import the sample application in the same workspace and give it a different ID, the alias is changed automatically so it's unique. However when you import an a...Aug 4, 2023·1 min read
Oracle APEX: the Power of the Activity LogsThe issue Have you ever had those moments when an end-user calls you out of the blue with a disturbing message about your app? It happened to me last week; an end-user called in a panic with the message, "all my inspections are gone!" FYI: This Oracl...Feb 22, 2023·5 min read
