CHAPTER 27Extending PL/SQL XML Functionality with Java

Starting with Oracle8i 8.1.5, Oracle Java Virtual Machine (Oracle JVM) has been provided as an execution environment for Java code running inside the Oracle databases. This functionality enables you to leverage Java functionality in PL/SQL by writing Java stored procedures.

In this chapter, we will help you understand how to build Java stored procedures to process XML data inside the database, including how to resolve URL references when parsing the XML data, and how to implement PL/SQL procedures to process XML in SAX. We will further provide suggestions to help you decide when to use Java stored procedures, and present some debugging and performance tips in the “Best Practices” section. ...

Get Oracle Database 10g XML & SQL: Design, Build, & Manage XML Applications in Java, C, C++, & PL/SQL 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.