Validations and Duplicate Page Submissions in APEX 5.1

I had a problem with a modal dialog page in APEX 5.1, which created new rows in a table on the database whenever the Create button was pressed. The problem was that if the user was very quick i.e. double/triple clicking on the Create button, then it was possible to create duplicate rows on the […]

APEX, APEX 5.1, Blog Validation / October 9, 2017

Read More

QuickSQL – Saves you time

One of the new features of APEX 5.1 definitely changed my way of creating DDL on Oracle databases. With the Quick SQL packaged application you only need to write minimal lines of markdown text to describe tables, triggers, audit tables and many other objects. This low code development concept can save you so much time, […]

APEX 5.1, Blog, Low Code / September 19, 2017

Read More

Moving to the Cloud: A Developer’s Perspective

I have been recently working with a charity who had developed a production APEX application and hosted it on apex.oracle.com. While this environment is brilliant for quickly creating a full APEX workspace and accessing from anywhere in the world, it is definitely not supposed to be used to host a production application (the environment can […]

APEX 5.1, Blog, Cloud, Explorer Cloud, Oracle Cloud / August 7, 2017

Read More

Presentation: A Review of Interactive Grid in APEX 5.1.1

Following on from my blog A Review of Interactive Grid in APEX 5.1.1; I presented a version of this at Scotland UKOUG event in June 2017. At the heart of this presentation; I wanted to discover more about what the User and Developer perspectives of this new region type were. For example; I wanted to […]

APEX 5.1, Blog / June 26, 2017

Read More

Client Side Validations

Since using APEX 5.1, you may have noticed a few differences in regards to client side validation when using a combination of: Compatibility Mode = 5.1 and Execute Validations on Buttons = Yes What you may have noticed is that client side validations are firing first; and only if the page is successfully validated will […]

APEX 5.1, Blog / June 2, 2017

Read More

A Review of Interactive Grid in APEX 5.1.1

A Review of Interactive Grid in APEX 5.1.1 This blog has been a long time in the making… Of course before writing a blog on any subject, you have to do your research. In my case, my research involved creating dozens (maybe in to the 100s) of Interactive Grids (IG) and writing a new Explorer […]

APEX 5.1, How to, Review APEX 5.0, Development, Interactive Grid, reporting, upgrade / March 29, 2017

Read More

Dynamic Theme Style in APEX 5.1

Dynamic Theme Style in APEX 5.1 One of the new features of APEX 5.1 is the introduction of APEX_THEME API which enables you to change the application theme style by user. A very nice APEX 5.0 feature is to allow users to change the theme style using the APEX_UTIL.SET_CURRENT_THEME_STYLE procedure (deprecated in 5.1) but this change […]

APEX 5.1, Explorer, How to Development, Style, Universal Theme / March 28, 2017

Read More

Customising chart colours in APEX 5.1

Customising chart colours in APEX 5.1 One of the new features of APEX 5.1 is the introduction of Jet Charts which are highly customisable using JavaScript and CSS. One particular issue I recently came across was the removal of two chart region attributes that allowed easy customisation of a chart, namely COLOR SCHEME and CUSTOM […]

APEX 5.1, Explorer, JavaScript Charting, JavaScript, reporting / March 13, 2017

Read More

Theme Roller not saving changes

Theme Roller not saving changes on a 5.1 ORDS standalone environment A very quick entry so we have this written down and so that it may help anyone in the future who faces the same problem.. We were having a problem on some of our new 5.1 environments where when using the theme roller and […]

APEX 5.1, Blog, Explorer, ORDS ORDS, RESTful, upgrade / March 9, 2017

Read More

Featured Posts