Tag Archive: APEX

Oct 04 2011

OOW 2011 – What’s New, Improved and Coming in Oracle Application Development

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 …

Continue reading »

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 …

Continue reading »

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 …

Continue reading »

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 …

Continue reading »

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 …

Continue reading »

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 …

Continue reading »

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 …

Continue reading »

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 …

Continue reading »

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.

Main page XFILES (included some created directories)

Click on the image to enlarge