Installing the Oracle XML Database component

The recent deployment project database encountered an error while compiling the package:


Package CTG. Ctg_csb_common compilation Error

Error: Pls-00201:identifier ' XMLDOM ' must be declared
Line: 124
Text: Function Getvaluebyxpath (Innode in Xmldom.domnode, Inxpath in Varchar2)

Error: Pl/sql:declaration ignored
Line: 124

Text: Function Getvaluebyxpath (Innode in Xmldom.domnode, Inxpath in Varchar2)

Reason: Missing Oracle XML Database component

To verify that XML DB is installed, you can use the Dba_registry view

Select Comp_name "Component" from Dba_registry;
Results:
Component
------------------------------------------
Oracle Database Catalog views

Oracle Database Packages and Types

Workaround: Call the Catqm.sql script to import this component

This script will create the XDB user

Recommended new table space for XML DB

Create Tablespace Xmldb_ts
DataFile ' d:\oracle\databases\ora10\xmldb_ts.dbf ' size 10M autoextend on MaxSize Unlimited
Extent management local uniform size 1M;

Of course, you can also use the Sysaux table space.

At the same time, the pool size should preferably be set large enough

alter system Set shared_pool_size = 80M scope=spfile;
If the shared pool size resets the amount, the database must be restarted.

Run the script. Note: This script can only be run by the SYS user.

When invoking a script, the following parameters are given:

Catqm.sql <XDB_PASSWD> <TABLESPACE> <TEMP_TABLESPACE>

@?/rdbms/admin/catqm Xml_password Xmldb_ts temp;

Verify that the creation was successful:

Select Comp_name "Component" from Dba_registry;

Results:
Component
------------------------------------------
Oracle Database Catalog views
Oracle Database Packages and Types
Oracle XML Database

If you want to unload XML DB:

Sql> @?/rdbms/admin/catnoqm
sql> alter tablespace xmldb_ts offline;
Sql> drop tablespace xmldb_ts including contents;

Ext.: http://blog.csdn.net/vvqboy/article/details/8169344

Installing the Oracle XML Database component