Accessing XML-SQL Utility

XML-SQL Utility (XSU) is provided with Oracle8i and it is made up of three files:

• $ORACLE_HOME/rdbms/jlib/xsu12.jar -- contains all the java classes which make up the XSU. The xsu12 requires JDK1.2.x or and JDBC2.x. This is the version of the xsu loaded into the database itself.

• $ORACLE_HOME/rdbms/jlib/xsu111.jar -- contains the same classes as xsu12.jar except that xsu111 requires JDK1.1.x and JDBC1.x.. JDK1.1.8 is the official JDK version supported by Oracle on the client side.

• $ORACLE_HOME/rdbms/admin/dbmsxsu.sql -- this is the SQL script which builds the XSU's PL/SQL API. xsu12.jar need to be loaded into the database before dbmsxsu.sql is executed. This script is automatically

By default the Oracle8i installer will install the XSU on your hard drive (in the locations specified above) as well as load it into the database. In the case that during initial installation you asked the installer not install the XSU, you can always run the installer later and have it install just the XSU and its dependent components. In this case the XSU will not be automatically loaded into the database; instead, you will have to take the following steps:

• If you haven't yet loaded the xmlparser for java into the database, go to $ORACLE_HOME/xdk/lib. Here you will find xmlparserv2.jar which you will need to load into the database. For how to accomplish this see "Loading JAVA Classes" in the "Oracle8i Java Stored Procedures Developer's Guide"

• Next go to $ORACLE_HOME/admin and execute the catxsu.sql script.

Note that the Oracle XML SQL Utility (XSU) is also available on OTN site: http: //technet.oracle.com/tech/xml. You can check here for XSU updates.