Richard Martens

Richard Martens has been involved in information technology for more than 20 years. He started as a web developer using the Oracle database as no more than data storage. Richard has been responsible for major European multilingual websites and has been working with the Oracle database since 2000. During those years, he developed himself using a multitude of technologies and specialized in PL/SQL and Oracle APEX. With APEX, he combines the things he loves most: the Oracle database and web technologies.

Changing Webserver

by

Please imagine the following: You started out with apex. And because it was the easiest installation scheme (apart from copying the ready-made virtual machine offered by Oracle free-of-charge ;-), you used the EPG-installation scenario. Lets suppose that by now you have gained a bit of experience and you want to use a proper webserver to … Read more

Execute Page process with Ajax callback

by

Sometimes you want to call a page-proces, but do need to make a compleet refresh of the page by making a request.

In my case i made a simpel master-detail screen with Tabs (Thank you Richard). In the tabs there are reports with a delete button for each row. For the delete operation i did not want refresh the complete page, but only wanted to call the page-proces i had written for the delete-operation and only wanted to refresh the report-region affected.

This is wat i did:

  • I made a normal report and added an icon for the delete operation. The icon for the delete operation is the id-column in the report (PRODUCT_VERWIJZING_ID) and has the follwoing column link properties:
    • link text: <img src=”#IMAGE_PREFIX#del.gif” alt=””>
    • target: URL
    • URL: javascript:del_verwijzing(#PRODUCT_VERWIJZING_ID#)

      • Read more

Apex installation notes

by

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

Installation and configuration

by

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)

by

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

by

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

by

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