13 XML

This chapter describes BS2000 specific topics of XML such as installation, features, and restrictions. For more information refer to Oracle XML Developer's Kit Programmer's Guide, Oracle XML DB Developer's Guide, Oracle Database XML C API Reference, Oracle Database XML C++ API Reference, and Oracle Database XML Java API Reference.

Installation of Xdk

The Oracle XML Developer's Kit (Xdk) is not part of the Oracle Database Product Set. Oracle recommends downloading the latest version of Xdk from the Oracle Technical Network OTN (Http://oracle.com/technology/tech/xml). The Jar files for The XML Sql Utility (Xsu12.jar, Xdb.jar) and the XML Parser (Xmlparserv2.jar) are already loaded in the database when you have followed the procedures explained in Creating and Upgrading a Database.

Features and Restrictions

The following table provides an overview of which XML features are available for which languages on BS2000.

The meaning of empty fields is: not supported.

N/A means: not applicable.

Availability for

XML Feature Java C C++ PL/SQL
Parser Yes     Yes
XSLT Processor Yes     Yes
Class Generator   N/A   N/A
Transviewer Beans   N/A N/A N/A
XML-SQL Utility Yes N/A N/A Yes
Schema Processor Yes     N/A

When using PL/SQL instead of Java you should expect the following behavior:

  • PL/SQL File input is only possible from POSIX and with ASCII-Data Format.

  • PL/SQL File output is written to POSIX with ASCII-Data Format.

  • For INSERT/UPDATE/DELETE operations the XML document must not contain <?xml ... encoding=WE8BS2000 ...>.

When using the JAVA-interfaces you have to ensure the right charset of the data. For more information, refer to the encoding considerations listed in Chapter 12, "Java in the Database".

If you have an ASCII platform with JDK, you can also use XML components and operate on the BS2000 Oracle database using a JDBC connection.

Database XML support (Oracle XML DB)

Oracle Database 10g supports XML in the server by a data type XMLType with predefined member functions, a PL/SQL package dbms_xmlgen to create XML from SQL queries, and a native implementation of SQL/XML functions XMLQuery and XMLTable for the support of XQUERY.

These features are already available when you have followed the procedures explained in the About Creating a JAVA Enabled Oracle Database 10g release 2 section of Chapter 4, " Creating and Upgrading a Database".

However, if you want to use the Oracle XML DB Repository, you have to run the following SQL script:


After creating a new tablespace and a new temporary tablespace in the database, you must run the following script:

SQL> connect / as sysdba
SQL> create tablespace xdb_resinfo datafile 'tablespace-xdb-data'
     size 100M autoextend on next 10M;
SQL> create temporary tablespace xdb_temp tempfile
    'tablespace-xdb-temp' size 10M autoextend on;
SQL> @$ORAC1020.RDBMS.ADMIN.CATQM xdb xdb_resinfo xdb_temp;

Note that Oracle Database 10g on BS2000 does not support WebDAV access, HTTP access, and FTP access, to the Oracle XML DB Repository.