Too much chrome

You know how it is, when you have that feeling. You are on top of your game. You have a few quick brush strokes to add to a system to make it more dynamic. You have all the small needed changes in your head and you know it is just (more...)

How to translate and use Apex text messages inside javascript code and other considerations about shortcuts

Always check out the original article at http://www.oraclequirks.com for latest comments, fixes and updates. For a long time I thought that whenever I had to display a translatable message inside JavaScript the only way forward was to create an Apex shortcut containing plain text. An Apex shortcut is (more...)

How do I turn off format autodection in Safari?

Always check out the original article at http://www.oraclequirks.com for latest comments, fixes and updates. Your Apex mobile page looks weird because Safari is formatting automatically certain strings containing numbers mistaking them for telephone numbers? You just need to add a meta tag in the head section of the (more...)

JSON parser for PL/SQL in Apex 5 ?

I was looking at the Apex 4.2.2 installation script (coreins.sql), and noticed the mention of a new package, wwv_flow_json, which is apparently being worked on but was removed at the last minute "as no longer required for 4.2.2".

Even though the package is not installed (more...)

Using Apex with IIS Express

The Thoth Gateway is a gateway written in C# and ASP.NET that allows you to run PL/SQL web applications (including Oracle Application Express) on Microsoft's Internet Information Server (IIS). You can read more about the gateway here. It is an alternative to Apache/mod_plsql and the Java-based Apex Listener.

For (more...)

Controlling Hide/Show Apex Regions Using Javascript

Hide/Show regions are very useful in that they allow users to hide certain on-screen content when it’s not relevant for them (and show it again just as easily) simply by clicking the small arrow icon in the top left of the region.

Image

 

But how can you programmatically do the (more...)

I am sailing…

Next week, I’m off for the OUGN Spring Conference that the Norwegian Oracle User Group arranges on board a cruise ship sailing from Oslo to Kiel and back. This event gathers the Oracle A-List, including Tom Kyte, Cary Millsap, Bryn Llewellyn, Mark Rittman, Markus Eisele and many others – it’s (more...)

Oracle OpenWorld Submissions – The Full Monty

Here one day before deadline, I have entered almost my entire current catalog of presentations for consideration in the Oracle OpenWorld 2013 agenda. One new for this year: “Worst Oracle ADF Project Ever” ;-)

If you would like me to speak at one of your events, the following are the presentations (more...)

The power of using records in APEX III

Uncategorized
| Mar 14, 2013

In this post I’ll finish up the CRUD implementation using records, procedures and views. This series of blog posts started with this post which was followed by this.

At this point we have a working report that links to a form. The report is based on a view and the form is based on a procedure. At this point the form is only loading the record in using a procedure that uses a record in its signature. In this post we’ll complete the functionality by using the same form for insert, update, and delete functionality.

Let’s start with adding a (more...)

TO_DATE or not TO_DATE

Like a middle aged man visiting the gym for the first time in 10 years, I am merely going to flex my blogging muscles here…

One of the recurring issues that annoys me on the OTN SQL & PL/SQL forum, and also the APEX forum is the misunderstanding of what (more...)

Mapping The World’s Energy On The Move…

Here's a link to a nice write up in Forbes on something that I was involved with over the last few years:

Thomson Reuters Eikon - Mapping The World's Energy On The Move


Oracle Locator and Spatial

If you already use Oracle Spatial or Locator then you probably already know Simon Greeners SpatialDB Advisor blog, but if not then I can recommend it as an invaluable source of Spatial nuggets.  Whether you are just starting out with Spatial or have some level of experience with it you (more...)

Apex and Graph Visualisation Libraries


I was recently asked by a client to create a quick POC in Apex to demonstrate how relationships between physical assets (in this case oil refineries) could be maintained using a graphical tool.  So I looked at a number of different Javascript graphing libraries and chose MXGraph from JGraph which (more...)

Work Yourself Fitter

It's been a while since my last blog post but as I'm now looking for my next Oracle contract (hopefully Apex again purrrlease) I've a little time on my hands.  So I thought I would share with you my latest creation.  It's a variation on the Treadputer which is basically (more...)

APEX: Using the Application Date Format Mask

In your APEX application, you can define several default format mask to be used throughout the application, such as the Application Date Format or the Application Date Time Format. This eliminates the need to specify the format mask for each Date Picker item that you use. It helps in keeping the application at least consistent regarding the format mask used.When you want to do some validation in your forms using the Dates entered by the enduser, you might have a need for the Application Date Format.So instead of hard coding (using the same format mask as you entered):

(more...)

Interview with Yalim Gerger (CEO Formspider – the PL/SQL Web Framework)

Uncategorized
| Feb 12, 2013
In every other profession having a 20 year experience is a good thing, in ours you are treated as a has-been who is kept around only to maintain the legacy system. This is insane.

Apex Text Messages as substitution strings – Wanted

Always check out the original article at http://www.oraclequirks.com for latest comments, fixes and updates. If you, like me, think that it could be useful having text messages available as substitution strings (ideally using the #syntax#) inside certain Apex's element attributes like button attributes, report links, form attributes and so on, then you might want to vote for this feature request

APEX: Highlight a Record in Report – with Dynamic Action

Yesterday I wrote a blog on how you can highlight a record in a report. That blogpost can be found here.Learco Brizzi posted a comment on a different way of accomplishing the same thing. And there are probably a number of other possibilities to implement the same requirement.In this blogpost I want to show you how to do the same with a Dynamic Action. Why would you want to choose for a Dynamic Action? This is a more efficient way because you don't need to refresh the page or the region. This blogpost will use a report based (more...)

APEX: Highlight a Record in Report

Yesterday I read a question which was posted as a reply to an earlier blogpost. The orginal blogpost was about how to make a Report Row clickable, instead of just the Edit column.The question was: "How do I keep the clicked row highlighted so I can keep it as context information?"To see a working example of the requirement, check out this sample pageIn this blogpost I will provide a step-by-step way of doing just that.For this to work properly, you will need a page with a report. In this blogpost page 9 will contain a (more...)

Presentation available for download

In November I have been presenting at the last DOAG conference in Germany about documentation in APEX projects ( http://daust.blogspot.de/2012/11/presenting-at-doag-next-week.html ). The presentation (only in German) is now available for download.

Cheers,
~Dietmar.