Posts Tagged ‘apex’

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 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 »

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 »

Oracle Apex application items

Have you ever wanted to pass data to an applicatino process but are fed uphaving to use a temporary global variable like GV_TEMP, or similar as a temporary placeholder for some data you want to pass from the page in javascript? var req = new htmldb_Get( null, 123, ‘APPLICATION_PROCESS=ap_dosomething’, 0 ); req.addParam( ‘GV_TEMP_VARIABLE’,’The value’ ); […]

Share
More »

Oracle Apex error – document.wwv_flow.submit is not a function

You might occasionally get this error in Oracle Apex when submitting a page. Alternatively, the page might not submit at all when you click a page button. I must admit this had me stumped and i had to resort to disabling everything, then reenabling region items to find out what was wrong. Turns out that […]

Share
More »

FISH Classification

The FISH tool was developed for the Scotland and Northern Ireland Forum for Environmental Research to classify fish populations in Rivers throughout the UK. The software was developed in Oracle with the new APEX 3.2 release. Custom HTML / CSS APEX templates were created including custom logon screens and admin sections. JQuery is used to […]

Share
More »

RICT

River Invertebrates Classification Tool is a software application that allows the Environment agencies to determine the ecology classification of water bodies throughout the UK. The software makes use of Oracle, XML, Web services, CSS, RSS and custom stastistical functions implemented in Oracle and ported from Insightful S+. Raw river data sets collected by ecologists are […]

Share
More »

Switch to our mobile site