How does one install the XDK capabilities on an Oracle Database?
Submitted by admin on Thu, 2005-12-15 06:31.
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.
»
- Login to post comments

