XML DB basic demo experience Oracle Headquarters Redwood Shores1 e1698667100526

XML DB basic demo experience

May 10, 2005 Database, Oracle 6 Comments

Introduction

Last week I have been investigating the XML DB basic demo at OTN (http://www.oracle.com/technology/tech/xml/xmldb/9.2.0.2.0/index.html, Downloadable Demo). Unfortunately there is also a similar but older demo at http://www.oracle.com/technology/sample_code/tech/xml/xmldb/index.html (Oracle9i R2 XML DB Demonstration).

The demo shows a lot of XML DB stuff. It is quite comprehensive with a few installation quirks. Those quirks may have been caused by using a brand new Windows XP laptop and an Oracle 10g database.

Installation

Follow the instructions in the basicDemo.pdf with the following remarks:

  1. The HTTP page for the Microsoft XML parser has been moved to http://msdn.microsoft.com/XML/XMLDownloads/default.aspx.
  2. Modify the script install.vbs to replace the following lines. 
    If not isNULL(iconPath) then
  oShellLink.IconLocation = iconPath
End if

    by

    If not isNULL(iconPath) then
  If (iconPath <> "") then
    oShellLink.IconLocation = iconPath
  End if
End if
  3. Unlock the Oracle scott account: 
    alter user scott account unlock;
  4. Grant unlimited access on the default tablespace for scott: 
    alter user scott quota unlimited on users;
  5. OracleSID in installParameters.xml is actually the TNS entry and not the ORACLE SID.
  6. Be sure to execute step 0.2 (Reset Demo)!

Demo

All examples run without any problems. The demo describes the following features of XML DB:

  • Storage of structured (XML schema) documents as well as non structured documents.
  • Access to the database via Internet Explorer (using the Webdav protocol).
  • Editing XML documents using Microsoft Word (using the Webdav protocol).
  • XPath, SQL and Oracle Text access.
  • XML stylesheet transformations (XSLT).

Conclusion

I think every Oracle developer/architect should run the demo. It gives a good overview of XML DB which enables developers/architects to decide whether XML DB can be useful in their projects. For me XML DB seems not only useful for storing XML but also for (simple) management content systems due to the support of the WEBDAV and FTP protocols.

Related Posts

About The Author

Gert-Jan Paulissen

Senior Oracle architect / developer (PL/SQL & Apex) / DevOps engineer. I am happy to be able to combine work and hobby. Software engineer since 1989. Bridge player since 1977 and dutch champion more than 10 times.

6 Comments

  1. hyun October 27, 2005

    I clicked on the 0.1 (initial setup) and 0.2 (reset demo) icons in the folder created in my desktop. But both of them prompt
    user name and password (entered scott/tiger) and nothing happened Are any scripts are associated with those icons?

  2. Sat Rahi June 23, 2005

    Hello,

    Thanks sooo much for your comments. I was running into the same errors.

    One question to you if I may ask. How do you evaluate XML DB performance wise?

  3. Mike May 29, 2005

    I am also using 10g and had the comple problem. I used your code fix, and now it works.
    Thanks so much!

  4. Marco Gralike May 13, 2005

    select * from dba_errors gives…?

  5. prabu May 11, 2005

    How did you get the xdb.xdb_configuration
    package to compile ? am also using a 10g db on xp and am getting
    comiplation errs on this package ,, however sho err doesn not show
    what the error is !

  6. prabu May 11, 2005

    I tried this demo on my 10 g db in my laptop.
    I could not get to compile the xdb.xdb_configuration pkg .
    Sho err doesnt shows no errors ! Not sure whats going on