Oracle provides a good alternative for using the EPG in single-developer projects. It is called the Oracle APEX Listener. it is intended to run as some kind of plug-in in: Oracle WebLogic Server. Oracle GlassFish Server. Oracle Containers for J2EE…
Monthly Archives: April 2011
Execute Page process with Ajax callback
by Sergei Martens • • 3 Comments
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 simple master-detail screen with Tabs (Thank you Richard). In the tabs there…
Apex installation notes
by Teun Luijbregts • • 1 Comment
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…
Installation and configuration
by Teun Luijbregts • • 0 Comments
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…
Create collapsible list (alternative to apex tree)
by Sergei Martens • • 0 Comments
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…
Tabs within APEX (using jQuery)
by Richard Martens • • 8 Comments
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…
Oracle APEX report refresh the easy way
by Richard Martens • • 9 Comments
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); //–>…
APEX built-in variables
by Richard Martens • • 0 Comments
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…