Uncategorized

Command Prompt here….

by

Nothing to do with APEX, but I really don’t want to forget this. As you might know, I’m a big fan of the command prompt. I’ve been using 4DOS/4NT/Take Command for years. These products are sold by a company called JP Software. But now they also have a free-ware product, which suffices for most of … Read more

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