Uncategorized

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

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

Ok. I just finished creating two extra Apex-environments (TEST and PROD) Where I mention “SQL>” you are logged in in your sqlplus as SYS as SYSDBA privileges. I now have a plan-of-attack for getting Apex 4 on a 10g database with EPG: Start the APEX installer (I unzipped my apex.zip into D:\APEX, so there is … Read more

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