Installation and configuration

Since Oracle is always advising to use the XE database it seemed only logical to try and see what the possiblities are, and how they compare. For those interested, this post shows the outcome of  my quick survey. 1. Use the download provided by Oracle a. Install VM (VirtualBox) b. Import machine c.  A working … Read more

Tabs within APEX (using jQuery)

The solution uses APEX 4 built-in jQuery libraries. The idea is to create a “containing region”, that is a region that will contain the sub-regions. Those sub-regions then will appear as a tab on your page. Create a template for the containing region Go to “Shared Components” – “Templates”, filter on Region Type templates: Press … Read more

Oracle APEX report refresh the easy way

I’ve seen numerous solutions for partial page refreshes. All using javascript, timers etc. I just want a report to refresh itself after 5 seconds. I add this to the region-footer: <script type=”text/javascript”> <!– setInterval( “$a_report(‘#REGION_ID#’.substring(1), 1, 7, 7);”, 5000); //–> </script> No extra javascript functions, no dificult parameters, works for multiple regions.. Essentially it will … Read more

APEX built-in variables

For all you guys ‘n dolls here an overview of the built-in apex variables and how/when to use ’em: APP_ALIAS APP_ID APP_IMAGES APP_PAGE_ID APP_SESSION APP_UNIQUE_PAGE_ID APP_USER AUTHENTICATED_URL_PREFIX BROWSER_LANGUAGE CURRENT_PARENT_TAB_TEXT DEBUG HOME_LINK LOGIN_URL IMAGE_PREFIX Application Express SCHEMA OWNER PRINTER_FRIENDLY LOGOUT_URL PROXY_SERVER PUBLIC_URL_PREFIX REQUEST SQLERRM SYSDATE_YYYYMMDD WORKSPACE_IMAGES taken from this source Variables can be referred to in … Read more

Apex listener v 1.1

I simply love the Apex Listener that Oracle sent out a couple of weeks ago. I now allways use it to do my (one developer = me) development, for a number of reasons. It’s easy to set up. I can edit my CSS and Images on the filesystem (no WebDav needed). It saves me resources … Read more

Command Line replacement

I’m a nerd. I know. I simply “love” the command-line. For years I’ve been using 4NT and TakeCommand, registered the product years ago (www.jpsoft.com). Now I made the switch to Windows 7 (64-bit). I still have to get used to it. Some Oracle issues on PL/SQL developer etc. When I wanted to install my command-lines. … Read more

Warp11 Apex plugins available

Today I published the plugins we’ve written to the plugin-library at www.apex-plugin.com. Warp11 CSS Menu The menu is based upon Jessica Wilson’s drop-down menu, but has unlimited levels and more control on the styles used. We also used a different JQuery plugin Warp11 GMaps item The item shows a Google map with some buttons within the … Read more