Oracle Insights and Answers



Solving Oracle problems for over 20 years

Calling PLSQL from Javascript

by Rodrigo Mesquita | Jan 29, 2019 | APEX, JavaScript

For those who came from an Oracle Forms world it is very easy to start working with APEX. When creating simple screens, you don’t need any jQuery or AJAX knowledge as dynamic actions help you. However, there comes a point where applications get more complex and we...

What is the Oracle Forms Standalone Launcher?

by Colin Archer | Jan 21, 2019 | Oracle Forms

I recently attended the Tech 18 conference in Liverpool and sat in on a few Forms presentations where the new Oracle Forms Standalone Launcher (FSAL) was mentioned. As an Oracle developer who has spent many years working with Oracle Forms I was interested to know more...

Apiary and APEX

by Craig Sykes | Jan 14, 2019 | API

More and more projects I work on at the minute make use of RESTful Web Services. These can either be a way of exposing our own data or a way to make use of data from external systems. They are easy to create in the Oracle Database to surface your own data – check out...

Creating an Online Leaderboard in APEX

by Craig Sykes | Jan 10, 2019 | APEX

In my spare time I like to play around with creating video games in technologies other than Oracle (!). I recently created a game for an online community that I participate in and I was asked whether I could create a leader board to go with it. I had never done this...

Case Study: Generis Technology Ltd

by Devon Page | Jan 8, 2019 | Case Studies

For the past 16 years, Generis Technology Ltd, a wholly owned subsidiary of the global Landis+Gyr Group, has supplied a suite of applications under the B-Smart brand which supports interaction in deregulated energy markets. Utilising an Oracle Forms user interface,...

UKOUG Tech 18 Debrief: New Universal Theme features in APEX 18

by Gavin Bell | Jan 3, 2019 | APEX 18

In my first blog (ever) I am going to give you a flavour of what I saw at the UKOUG Tech18 Conference in Liverpool. At the conference, I was mainly concentrating on the talks relating to the new features of APEX 18 and Universal Theme. I attended two of Shakeeb...

APEX Report Performance

by Paul Jones | Jan 2, 2019 | APEX

Recently at the UKOUG TECH18 Conference I gave a presentation entitled ‘Choosing the Right Report & Features to Give your Users when Presenting Data in an APEX Application’ which you can read more about here. During the presentation, one of the common problems...

Making an APEX Wizard Clickable

by Colin Archer | Dec 20, 2018 | APEX

Recently I was at the Tech 18 conference in Liverpool where I went to an APEX presentation by Adrian Trotman on the power of lists. During his presentation (which was good by the way), he gave out a challenge to the room. He asked if anyone could make the wizard list...

The Numerous Options for APEX 18.1 Interactive Grid Validations

by Matt Mulvaney | Dec 19, 2018 | APEX

I’ve written a number of blogs lately; however the one I am quite fond of is the one I did on Client Side Validations back in 2017. I look favourably back on this because it piqued my interest of what APEX is capable of in this area. I purposely omitted Interactive...

UK OUG Tech18 APEX State Of The Union

by Philip Ratcliffe | Dec 17, 2018 | APEX, Review

If, like me, you attended UK OUG’s Tech18 conference at ACC Liverpool and have a particular interest in Application Express, you may well have attended Joel Kallman’s “State Of The Union” address. This blog is a review of Joel’s presentation, and of the key messages...