Archive for the ‘Coding samples’ Category

oracle apex checkbox select all

Recently I needed to add a check box column to an interactive report on Oracle 4.2. I used the APEX_ITEM functionin my report’s SQL to generate the checkbox, but I needed a Check All option on the column header. Simple, just rename the column header: [input type=”checkbox” onclick=”$f_CheckFirstColumn(this)” /> This was implemented after repeated requests […]

Share
More »

Oracle XMLDB custom authentication for webdav / http

Oh what joy Oracle has brought me today!! I’ve been struggling for a few days trying to work out how best to integrate Oracle and Active Directory to allow users to map a drive letter to Oracle XMLDB to use it as a file store, extract EXIF, lat / lon and so on… I’d finally […]

Share
More »

Oracle on Amazon RDS with APEX listener

I’m in the process of setting up Oracle 11g with APEX and XMLDB on Amazon Web Services. I thought i’d document the process and what i do to get it all (hopefully) working together. Also, this will act as reference document for me when I do it again later this week. So here we go… […]

Share
More »

How to set Oracle Apex Checkbox default value

By Craig Glendenning As often is the case when I blog about something, I spent waaaaay too much time trying to figure out how to do something that is seemingly very simple. In this case my trivial requirement was to create a single checkbox, that when checked, puts “Yes” in the database, and when unchecked, […]

Share
More »

Vertical text in javascript

I’ve just recently been given a Word document with a mock up of a report that I needed to reproduce in HTML. Well, i looked at various options like using transforms, rotate, DX filters in IE, but none of them worked properly, or without major headaches. Whilst searching around, I found a JS library called […]

Share
More »

Oracle APEX radio groups as buttonsets

Buttonsets are sometimes appropriate to represent a choice of selections instead of radio buttons. I think they look much better – especially when used for smaller lists. Sub lists can be shown or hidden easily using dynamic actions in APEX 4.

Share
More »

Getting the server name in Oracle 11g

In an APEX application i’m creating, I’m storing some output files that the public needs to get access to on the XMLDB server. The problem is, when i’m moving my code to production, I need to update the location to send the users to. Previously, I’d used global variables in a Global package to store […]

Share
More »

Oracle Apex sticky hide and show regions

Recently had a need for sticky hide/show regions in Oracle Apex 4.1. Here’s how I done it. Add the jQuery cookie library to your page template Added the following line to the hide and show region template ?View Code HTML1 $.cookie(‘#REGION_STATIC_ID#’,$(‘##REGION_STATIC_ID# .hide:first:visible’).length);return false; So my hide and show region template looks like this: ?View Code […]

Share
More »

Creating ACLs in Oracle 11g

In Oracle 10g, network access was pretty easy. Just fire up a UTL_HTTP request and voila, you’re data appears. In 11h, everything is locked down, here is where Access Control Lists (ACLs) come into play. To allow a user to access external resources, i.e. web content, you must create an ACL, assign users or roles […]

Share
More »

Android SDK install error

Spent ages trying to get Andoid SDK ¬†installed¬†and configured so that I could get to grips with Appcelerator mobile development tool working. Kepy on saying I didnt have a SDK installed Oh how annoying. I tried: Installing an older version of JDK Installing JRE, JDK, SDK, ImOK…. nada Changing my PATH variable until Id went […]

Share
More »

Switch to our mobile site