Richard Martens

These are -some of- the notes I made when installing Oracle Apex 4.0.2 in a RedHat Linux environment (scenario 4 of my previous post). ## Mount folder located in filesystem in VM [ ~]# su – root [root@a005 ~]# mkdir /mnt/vmshare [root@a005 ~]# mount -t vboxsf vmshare /mnt/vmshare ## Wat is mounted? [root@a ~]# mount … Read more

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

After some testing en struggling with the Apex-tree item I decided to look for an alternative for an expanding and collapsable html-list. Because of the integration with Jquery in apex, i obviously looked for an apex plug-in and found a really ease one. The plug-in is written by Milaju and the source and documentation can … Read more

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

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

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

Hi there, Yesterday I installed Firefox 4 and Internet Explorer 9. Wow beautyfull browsers.. both of them. However yesterday I allready found out that IE is not diaplaying the AnyChart charts in my Apex applications. So IE9 for now is a no go.. pitty. Today I also found out that Firefox 4 has issues with … Read more

Roel posted a great coverage on the Oracle APEX day on his blog: http://roelhartman.blogspot.com/2011/03/ogh-apex-day-2011.html Definately worth reading…  

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

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