XFiles – An APEX Community Effort

Marco Gralike

Just so you know, there is an APEX demo app. out there that never has seen the light. The demo application based on Mark Drake’s (Sr. Product Manager Oracle XMLDB)  XFiles xmldb demo application build with Javascript, Java & PL/SQL. Carl Backstrom helpt Mark in 2008 to rebuild the same demo app. into an APEX look and feel demo application. Carl wanted to clean up the code but never came around to it… I recieved the code from Mark, after a year has passed after Carl’s tragic death, and I am trying to get it out there (if applicable on http://apex.oracle.com). The XFiles demo application is a lightweight Content Management System that demonstrates all the things possible with Oracle XMLDB functionality.

The installation dependancies have been almost now figured out by me and I have finally something to show.

XFILES Apex Folder Browser Main Page

Have a look at the posts on XFILES – In Rememberance of Carl Backstrom

It is a lot of “reverse”-enginering work, fitting the pieces together, grabbing code from all over the place on the internet, and although I think myself proficient after working for 15 years or so with the database, progress has been slow. I already spend a lot of free time into it, trying to figure things out to create an installation manual that I will add to the code the moment I will send it off into the community.

To suppress myself from wanting to do it too perfect, I restricted myself via a promise that I will release whatever I got, before the Dutch Sinterklaas bank holiday (5 December).



If you need a start into XMLDB, and/or (propably/I don’t know the exact presentation content) want to see the XFiles in action, then see Marks presentation during this years UKOUG Conference Series Technology & E-Business Suite, in Birmingham, called: “Overview of Oracle XML DB in Oracle Database 11g

Next Post

Oracle 11gR2 - alternative for CONNECT_BY_ISLEAF function for Recursive Subquery Factoring (dedicated to Anton)

On our blog, we have been discussing the new hierarchical query functionality in Oracle Database 11g Release 2, using Recursive Suquery Factoring. Instead of using CONNECT BY and its close associates such as START WITH, PRIOR, LEVEL and more exotic comrades like SYS_CONNECT_BY_PATH, CONNECT_BY_ROOT and NOCYCLE this release gave us […]
%d bloggers like this: