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

Manage HTTP Access in Application Express 3.0

Wow, Richard and I have been strugling with APEX 4 on XE for hours before we came across this port: http://www.emarcel.com/database/143-apexhttpccess It would have saved us hours.. thanks Marcin! <COPIED BLOG> After default installation of Oracle APEX 3.0, remote users are not allowed to access Database home page (APEXconsole) http://127.0.0.1:8080/apex http://localhost:8080/apex http://hostname.com:8080/apex (not allowed by default … Read more

Manage HTTP Access in Application Express 3.0

Wow, Richard and I have been strugling with APEX 4 on XE for hours before we came across this port: http://www.emarcel.com/database/143-apexhttpccess It would have saved us hours.. thanks Marcin! <COPIED BLOG> After default installation of Oracle APEX 3.0, remote users are not allowed to access Database home page (APEXconsole) http://127.0.0.1:8080/apex http://localhost:8080/apex http://hostname.com:8080/apex (not allowed by … Read more