If you are using Oracle REST Data Services
as the "PL/SQL Gateway" for Oracle Application Express
, ensure that your ORDS configuration includes the following line:
It is important that you do this, and let me explain why.
Fundamentally, the APEX "engine" is really nothing more than a big PL/SQL program running inside the Oracle Database. When a browser makes a request for a page in an APEX application, that request is mapped (more...)
In my summer holiday, this year in Stockholm (Sweden), I will make a stop and present two APEX topics in the "Stockholm Oracle Meetup group".
The topics will be:Working with interactive SVG graphics in APEX
Adding SVG graphics inside individual business applications is quite in common. Because those graphics can increase the usability and even more important it creates a completely new way to visualize data inside a browser app. In this presentation he (more...)
As announced on Twitter, Oracle APEX Patchset 5.0.4 is released. Download the full release or get the Patch 23192730 from support.oracle.com.
What’s new/changed, besides the obvious listed in the Patch Release notes?
- got an improved security check. They now look for read privilege on the apex-admin-role instead of full admin privileges.
- APEX_DEBUG_MESSAGES finally lists the Call Stack where a message was written (level 9 debug, only)
- new View APEX_INSTANCE_PARAMETERS
At my current project we use Interactive Reports heavily. But in some cases the underlying queries are rather complex and a query without any filter or with just a filter on all columns doesn't perform that well (understatement...). We already implemented a solution to prevent initial loading of the data by adding an additional criterium to the query ( :P400_SEARCH = 'Y'
). The default value of this hidden item is 'N' and on (more...)
Since the genesis of Oracle Application Express
, customers have asked for a way to open multiple browser tabs (or windows) of an APEX application and have the session state isolated between the respective tabs. There is one and only one APEX session associated with a client, and because of this behavior in APEX, customers would find that the session state manipulated in one browser tab would collide with the session state of the other (more...)
Most of you know the default APEX edit icons you can choose from inside your Interactive Report.
Basically you use them to link to a detail page.
The icon source looks like this.
A typical result page.
Two things I would like to change:
1. The Icon should be a nice looking car symbol from the Font Awesome library.
2. The column width should be as small as the icon and not relative to the (more...)
Resetting an Interactive Report (IR) can be done in 4 different ways.
User Reset, URL Link, Page Process, Dynamic ActionFirst of all
It is always a good start to set up a specific static report id.1. User Reset
Not much to say.
1. URL Linkf?p=&APP_ID.:1:&APP_SESSION.:::RIR,CIR:
- RIR: reset IR to primary report
- CIR: reset IR to primary report but with custom columns (more...)
Vor kurzem musste ich Daten aus einer Excel-Liste in das SDO_GEOMETRY Format bringen. Leider hatte die Excelliste einen Haken.
- Es musste eine Linie (Typ 2002) im GK3 Format (31467) aus VON und NACH Punkten generiert werden.
- Die Excel-Liste hatte die Punkte entweder als GK3
oder als WGS84
Nach Import der Daten sah meine Quelltabelle dann so aus:
Und hier das Select zur richtigen Transformation der Geo-Daten ins SDO_GEOMETRY Format:
If using universal theme, we can switch from a classic navigation bar to a list and display it where usually a navigation bar is displayes - right top of the page. The problem with the list is that it will escape any html code in the list name. If we want to display an image, we will get the html code. To go arround that problem, we can use the "user defined attributes" for the (more...)
Since APEX 5 it is much easier to create master-detail pages with modal dialogs. But there is still no declarative way to create a conditional row based column link.
This blog post will show you a way how to create a conditional row based master - detail page.
1. We need some sample data:
WITH MY_DATA AS
select 1 as ID, 'APEX Connect' as name, 1 as CONDITIONAL_COL from DUAL
select 2 (more...)
While creating pages with the new UT I noticed that the breadcrumb breakes after the second level and this takes too much space.
And this is how it looks like after applying the css.