How does one install the XDK capabilities on an Oracle Database?

For Oracle 9i and above:

  • Ensure the Oracle JServer Option is installed. See the JServer/JVM FAQ.
  • Run SQL script $ORACLE_HOME/rdbms/admin/initxml.sql to load the XSK into the database.

Install steps for older versions (Oracle 8i and below):

  • Ensure the Oracle JServer Option is installed. See the JServer/JVM FAQ.
    *]Run SQL script $ORACLE_HOME/rdbms/admin/catxsu.sql to load the XMLSQL Utility (DBMS_XMLQuery) into the database.

  • Note that the following line is commented out in file catxsu.sql:

    -- call sys.dbms_java.loadjava ('-v -r -grant PUBLIC xdk/lib/xmlparserv2.jar');

    Run the above command manually from OS command line:

    $ loadjava -v -r -grant PUBLIC $ORACLE_HOME/xdk/lib/xmlparserv2.jar

  • Load the XMLParser into Oracle by executing $ORACLE_HOME/xdk/plsql/parser/bin/load.sql
  • Grant users access to XMLParser and XMLDom packages:

    grant execute on xmldom to public;
    grant execute on xmlparser to public;
    create public synonym xmldom for sys.xmldom;
    create public synonym? xmlparser? for sys.xmlparser;

  • Use the DBMS_XMLSave, DBMS_XMLQuery, XMLDOM and XMLParser procedures in your programs.