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 [...]

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’ ); [...]

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 [...]

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 APEX templates were created including custom logon screens and backend functionality. JQuery is used to provide a more [...]

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 [...]