Appendix A. XML Helper Packages

This appendix includes the PL/SQL package implementations for the XML helper packages we used back in Chapter 5:

This appendix also contains instructions on how to install these packages in your Oracle8i database.

Installing the XML Helper Packages

To install all of the XML helper packages we used in Chapter 5, follow these steps:

Change directory to the ./examples/appa directory, which contains the files for this appendix.
Connect as SYS using SQL*Plus and run the install_sys_helper_packages.sql:
```
sqlplus sys/change_on_install @install_sys_helper_packages.sql
```

Compile PropertyHelper.java and use loadjava to load it into the database as SYS:

javac PropertyHelper.java
loadjava -verbose -resolve -user sys/change_on_install PropertyHelper.class

Connect as XMLBOOK using SQL*Plus and run the install_helper_packages.sql script:
```
sqlplus xmlbook/xmlbook @install_helper_packages.sql:
```

Get Building Oracle XML Applications now with the O’Reilly learning platform.

O’Reilly members experience books, live events, courses curated by job role, and more from O’Reilly and nearly 200 top publishers.