view counter

Feed items

Introducing Slack to the Oracle APEX community

If you're like me, the first time you ever heard of Slack was when you checked out launch last month.

Since then I've signed up, had a play, interacted with people and with the support of I thought about what it could do for our community. Slack's mission is “make your working life simpler, more pleasant and more productive.” To me that sounds like something we should think about getting involved with.

ODTUG APEX Gaming competition submission - Boggex

This post announces my humble attempt for the ODTUG APEX Gaming Competition 2015.

You can play the game yourself at
The about section allows you to download the current source I have exported.

Permission to board,

Let's see, what happened in the last 24 hours or so? announced, everyone feeling the awesome.

I joined slack, I must say the curiosity rover self portrait helped sway my decision.

Got involved in some geeky discussions, bounced some ideas around.

Put my hand up to help with content.

Now involved in project.

APEX 5.1 revised SOD and

Two big announcements, one awesome product.

Statement of Direction

Today I think David Peake saw the wave generated by the announcement of and decided to also announce a revised Statement of Direction (SOD) for APEX 5.1, or he could try convince me it was a coincidence.

The Oracle Development Community is Buzzing

I don't know about you, but it sure seems like a fire was lit somewhere in Oracle and now there are all sorts of things going on in the development community.

Generating JSON from SQL cursor

It appears there will be a good 1001 uses for the APEX_JSON package in APEX 5, here is one of them.

Previously I had an AJAX PL/SQL callback that returned a relatively simple JSON string, using the LISTAGG technique described by Lucas here.

l_json varchar2(32767);
select listagg('{"id":"'||version||'","content":"'||version||'.x"}',',') within group (order by null) json

Review: The Martian

I think we have a new genre of films for those consumers yearning for science and exploration.

First Gravity took us on a cinematographic journey into low earth orbit.
Then Interstellar took us on an inception style ride.

APEX 5 Change Workspace Authentication

APEX has provided the ability to authenticate your application users against an LDAP server for quite some time.

APEX 5 now provides us the ability to change how we log into the development builder itself, and it's surprisingly easy.

Recently I modified our APEX 5 sandpit to authenticate against LDAP, so we can use our Windows passwords logging into the APEX Development Builder - one less password to manage.

APEX 5 Verify Theme Subscription

I was attempting to replicate the navigation bar example from the Opportunity Tracker application and I noticed my application was missing icons from the sub list dropping off the username.

APEX 5 Source Used attribute - tolerating less mistakes

If you've upgraded to APEX 5 and find yourself with an error complaining about the 'Source Used' attribute:
then you should thank APEX 5 for finding (and no longer tolerating) a logic bug in your application.

view counter