13
XML

This chapter describes BS2000 specific topics of XML as installation, features and restrictions. For more information see Oracle9i XML Developer's Kits Guide, Oracle9i Database Developer's Guide and Oracle9i XML API Reference.

Installation of XDK

The Oracle XML Developer's Kit (XDK) is not part of your Oracle Server product set. Oracle recommends to download the latest version of XDK from the Oracle Technical Network OTN (http://technet.oracle.com/tech/xml). From the directory you downloaded the XDK software (e.g. .../lib) you can load these *.jar files into the database by following call within SQL*Plus (and ensurance of necessary permission for user):

call sys.dbms_java.loadjava('-v -r -grant PUBLIC -synonym lib/<name>.jar');

For PL/SQL load the PL/SQL wrappers with SQL*PLUS by calling the following scripts:

File	Comment
XMLPKG.SQL	Wrappers for XML-Parser and XSLT-Processor
XSUPKG.SQL	Wrappers for XML-SQL-Utility

For more information see Oracle9i XML Developer's Kits Guide chapters ,,Using XML Parser for PL/SQL" and ,,Installation of XDK for PL/SQL".

Features and Restrictions

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

The meaning of empty fields is: not supported.
N/A means: not applicable.

XML feature	Availiability for
	Java	C	C++	PL/SQL
Parser	Yes			Yes
XSLT Processor	Yes			Yes
Class Generator		N/A		N/A
XSQL		N/A	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 this behaviour:

• 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 your data. For more information see the encoding considerations of chapter "Java in the Database".

If you have an ASCII-Platform with JDK, you can also use XML-Components there and operate on the BS2000 Oracle database over JDBC connection.

Database XML support (Oracle XML DB)

In Oracle9i XML support in the server has been extended by a new datatype XMLType with predefined member functions and a PL/SQL package
dbms_xmlgen to create XML from SQL queries.

These features are already available when you have followed the procedures explained in chapter 4 about creating an Oracle9i Release 2 database.

If you want to use the Oracle XML DB Repository, however, you have to run the SQL script

catqm.sql <XDB_PASS> <XDB_TS_NAME> <TEMP_TS_NAME>

after database creating and after creating a new tablespace and a new temporary tablespace, e.g.:

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> @$ORACL920.RDBMS.ADMIN.CATQM xdb xdb_resinfo xdb_temp;

Make sure that the database is started with Oracle9i Release 2 (9.2.0) compatibility or higher.

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