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.
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.
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.
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.
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:
catqm.sql XDB_PASS XDB_TS_NAME TEMP_TS_NAME
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.