XDK Sample Code:
Building Server-Side XML Schema Validation

August 2001

XML Schema Validation can provide a flexible and portable form of data validation for use in your applications. You may implement the XML validation process in your client-side or mid-tier applications, but if you want either:

• Absolute control of data validation whenever the data is updated/inserted
• Make use of the data management capability of the Oracle database

This data validation process is implemented inside a trigger callable from PL/SQL procedures on the server-side. Since there is not a built-in PL/SQL API to do XML Schema validation, we can create one using Java Stored Procedures.

This sample gives an introduction to the XML schema validation process with the XDK for Java and discusses how to build an Oracle Java Stored Procedure to perform the schema validation on the server-side of the Oracle Database. The included sample also demonstrates the deployment procedure for Java Stored Procedures.

Prerequisite:

• Oracle Database 8.1.6 and above.
• XML Developer's Kit (Java Package), e.g. xdk_java_9_0_2_0_0B.tar.gz

Document

• Building Server-Side XML Schema Validation

Download the Demonstration

The download includes the installation instructions, Java and SQL source code.

• Download Sample Code

Related Documents

• Oracle9i Java Stored Procedures Developer's Guide
• Oracle9i XML Reference