Just a quick note to say that there's a new patch for Oracle Application Express that fixes a number of issues and also adds some enhancements to APEX (e.g. two new themes, API additions to APEX_UTIL etc.)
Saturday, November 20, 2010
Wednesday, November 17, 2010
The APEX Development team updated the Statement of Direction for the future releases of Oracle Application Express.
- Development for Mobile Applications – Include themes and HTML templates suitable for smart phones and mobile devices.
- Charting - Provide for chart rendering without using Flash (to enable display on mobile devices).
- Error Handling - Improve error handling and user-defined exception processing.
- Interactive Reporting – Allow multiple reports on one page and support pivot queries.
- Tabular Forms – Allow multiple tabular forms on one page and continue to expand tabular forms validations.
- Master-Detail-Detail – Allow the generation of pages to support master-detail-detail relationships.
- Dynamic Actions – Enhance conditional processing and allow dynamic actions to be defined for tabular forms, reports, and buttons.
- Plug-Ins - Add plug-in support for additional components and enhance plug-in definitions.
- Use of ROWID – Allow usage of ROWID for Automatic DML processing (as an alternative to identifying the PK columns).
- Modal Dialogue - Add ability to display a dialog on top of a page (the rest of the page will be grayed out).
- Websheets – Allow for greater control over user interface, new page section types, and enhanced spreadsheet / datagrid integration.
- Data Upload - Enable end-users to upload data into an existing table (within an application).
- Accessibility – Improve accessibility in existing themes and HTML templates.
- Numerous functional and performance improvements.
Sunday, November 14, 2010
Saturday, November 13, 2010
I'll have to push back the release of APEXBlogs version 2 for some time. Most of the development is completed, but I'm still working on the new UI of the site. Before going live I also want to do some blog posts about what will be in this release, so if some of you have comments I can still consider these and possibly make changes. There are at least five other blog posts waiting, before the go-live...
At this stage it aggregates the Oracle Plugins page and the Community Plugins rss feed. I decided to keep it like that for now and am not including other personal links to APEX plugins, but might consider to do that in the future if I see they don't get posted in the ones I aggregate now.
Monday, November 08, 2010
Another new feature of APEXBlogs v2 will be the synchronisation of Tweets with the hashtags of #apexblogs and/or #orclapex.
from xmltable(xmlnamespaces('http://www.w3.org/2005/Atom' as "AE"), '//AE:entry'
columns title varchar2(250) path '/AE:entry/AE:title/text()'
The above query would be easiest, but it won't always work. It depends the version of your database, your security settings and your environment.
Saturday, November 06, 2010
The main reason for APEXBlogs was to aggregate the blog posts and be able to search in an easy manner.
Friday, November 05, 2010
Posted by Dimitri Gielis at 08:48
Thursday, November 04, 2010
This post is part of the The 10 days of APEXBlogs.
APEXBlogs itself is just the UI, in the backend you have packages (using XMLDB features) that connect to all the blogs and searches for changes. If it finds changes it will merge these changes in the tables APEXBlogs is build on. There are a couple of issues with this method:
- The more blogs you have, the slower it gets to look for changes as it needs to connect to the blog, read, search for changes, disconnect, connect to the next blog, read, search for changes etc.
- It not only became slower, it also used a lot of resources (CPU and memory)
- There are different kinds of blogs e.g. WordPress, Blogger (Blogspot), WindowsLive etc. You would expect the RSS format is universal, but it isn't, so I ended up with different code for the different kinds of blogs.
- The package was quite sophisticated as it could recognise the type of blog, but I got into trouble when people started to use their own urls (.com)
Wednesday, November 03, 2010
On March 29, 2011 the Oracle Benelux User Group (OBUG) will hold its 4th OBUG Benelux Connect.
As in previous years, this event is being organized in close collaboration with Oracle.
Possibly you were one of the 700 visitors who attended the 2010 event at the Papendal Conference Centre in Arnhem, The Netherlands in March earlier this year and you are eager to present your customer case at the upcoming OBUG Benelux Connect 2011.
OBUG Benelux 2011 will be held at SQUARE Brussels Meeting Centre in Brussels, Belgium. Square is housed in an elegant, architecturally significant building originally constructed for the 1958 World Expo.
The theme for OBUG Benelux Connect 2011 is "The Real User Experience".
The strength of OBUG Benelux Connect is the customer cases presented by OBUG members and other Oracle customers. Learn from peers to maximise the value of your business-critical applications and technology.
Speakers will share their experiences and business solutions with you in more than 40 sessions scheduled in different streams: Applications (Oracle eBS, Peoplesoft, Siebel, JD Edwards, Primavera), Technology (DBMS, JDeveloper/ADF, etc.), Middleware (BPEL, SOA, EAS, etc.) & Business Intelligence (Hyperion, OBI, GRC, etc.). There will also be a complete APEX track.
CALL FOR PRESENTATIONS
End-users, project leaders, implementers, IT and functional managers and CIO´s share your experience with Oracle products in a 45-minute presentation – (slides to be prepared in
English, presentations to be given preferably in English). You can submit your abstract here.
As in analogy with "The 14th Days of jQuery" I plan to write the next 10 days a blog post about the new features in APEXBlogs v2 (release planned for November 12th).
For the people that don't know APEXBlogs yet; I created that site for a couple of reasons:
- Give the APEX community an easy access to the most interesting blog posts about APEX
- Backup the content of the blogs, so even when a blog would disappear, the info around APEX would not be lost
- Have links to the other interesting sites about Oracle Application Express
- To promote APEX
- Show what you can do in APEX. The initial release of APEXBlogs was written in April 2008, at that time APEX 3.0/3.1 and showed the integration of jQuery and other 3rd party components.
An older screenshot of APEXBlogs:
I leave the current APEXBlogs site running, but am not doing any development or maintenance on it anymore. That means some links are out of date or some blogs don't get synced correctly. I'm sorry for that, but I decided to put my energy in the new version.
I started version 2 of APEXBlogs a couple of months ago and decided to build it again from scratch in APEX 4.0. Version 2 is working in parallel for some time now and is syncing the blog posts, so any blog post written as we speak will appear in this new version when it goes live.
I'm very excited about this new version of APEXBlogs, but at the same time I've a lot of competing priorities, so lets see what will make it in the release of the 12th of November ;-)