Currently at Tom Kyte’s session regarding topics new, improved or coming in Oracle Application Development. Tom told about the history APEX has gone thru and the current setup with the APEX Listener and even the “PL/SQL Gateway” was mentioned. I always have to laugh a bit because this last one touches the XDB Protocol Server …
Tag Archive: APEX
May 27 2011
The Oracle XMLDB “anonymous” user account
Trying here to be as correct as possible, as far as I understand it currently. ANONYMOUS is an Oracle user account specifically designed for HTTP access. It has only one system privilege, that is “create session” and the account is locked by default. If it is unlocked, it only is used for HTTP access via …
May 19 2011
XFILES APEX Community Edition (XACE)
Roel Hartman and me are currently very busy with our Kaleidoscope 2011 presentation “XFiles, the APEX Version: The Truth is in There…“. During this presentation, we will demonstrate the awesome possibilities you can create when you combine the APEX and XMLDB functionality of the APEX database environment. And as you probably also know, two “no …
Nov 08 2009
XFILES (Part 3) – The APEX Look and Feel
Had my adventures today. Most of the packages are compile and the XDB utility packages are in place (will come back on those in a later post). Apparently as said before, Mark has added some extra new functionality “Application Security” for use with APEX. This almost locked me out today after bringing into place all …
Nov 06 2009
XFILES (Part 2) – APEX Newbie Enhancement Requests
Its not yet “the breeze” I hoped for in regard to “Installing XFiles” on APEX. I am missing parts of the source that XFiles in APEX is build upon and although I know where I can get it, it is not easy to implement it “The APEX” way. For example XFiles is depending on XDB …
Nov 01 2009
XFILES (Part 1) – In Remembrance of Carl Backstrom
There is a demo application out there for Oracle XMLDB, called XFILES, that demonstrates the Oracle XML database functionality. During Oracle Open World 2008 I attended a presentation of Mark Drake, Sr Product Manager XMLDB and Carl Backstrom, called “Oracle Application Express and Oracle XML Database: A Match Made in the Database“. Mark had build …
Jun 09 2008
Using SQL*Plus as a Webbrowser, RSS feeder, Google Map data provider and more…
Dimitri Gielis had last Sunday a XML related question for me about the XMLDB extract function and the use of multiple namespaces. He needed the solution for the (beta) Google Map tab in DG Tournament. You probably know the following DBURI function (available / supported since 9.0.?): HTTPURITYPE The following is a simple example regarding …
May 14 2008
XML Posts After One Year
I once started this website because of the steep learning curve regarding XMLDB functionality. After one year of existence the following posts were written by mean , for me as a notepad to remember what I have learned and or checked, tested or figured out and to pass it on to all those who are …
Sep 13 2007
XFILES – XMLDB Content Management Example Application and More…
The XMLDB team has posted a demo application on the XMLDB section of OTN called XFILES. This application is a demonstration of almost all important features of the Oracle 11g XMLDB functionality, deployable on Windows or Linux platform, combined with technologies like AJAX and Oracle Text.

Recent Comments