problems with XmlSchema

From: Ko van der Sloot <Ko.vanderSloot_at_uvt.nl>
Date: Fri, 25 Nov 2005 14:28:30 +0100
Message-ID: <dm73hv$i1r$1@troll.uvt.nl>

to start with:
SQL> select * from v$version;

BANNER

---

Oracle9i Enterprise Edition Release 9.2.0.6.0 - Production PL/SQL Release 9.2.0.6.0 - Production
CORE 9.2.0.6.0 Production
TNS for Linux: Version 9.2.0.6.0 - Production NLSRTL Version 9.2.0.6.0 - Production

I have some strange problems using the mods schema (http://www.loc.gov/standards/mods/v3/mods-3-1.xsd )in Oracle. I was able to register and use a home-made schema, but with mods I get very unhelpfull error messages.

To demonstrate, try the following script:

> begin
>
> dbms_xmlschema.registerURI( 'uritest1.xsd', 'http://www.loc.gov/standards/mods/v3/mods-3-1.xsd' );
>
> end;
> /
> drop table mods_test;
>
> create table mods_test ( doc_id VARCHAR2(64) PRIMARY KEY,
> arch_id VARCHAR2(10),
> data_char xmltype NOT NULL )
> xmltype column data_char XMLSCHEMA "uritest1.xsd" element "mods";
> .

Executing this:

> SQL> @mods_test
>
> PL/SQL procedure successfully completed.

so the schema IS registered

> drop table mods_test
> *
> ERROR at line 1:
> ORA-00942: table or view does not exist

so far so good

> create table mods_test ( doc_id VARCHAR2(64) PRIMARY KEY,
> *
> ERROR at line 1:
> ORA-00600: internal error code, arguments: [qmtcolinfo_cbel], [], [], [], [],
> [], [], []

No clue here....

Another problem is, that this schema is very hard to get rid of:

> SQL> begin
> 2 dbms_xmlschema.deleteSchema ( 'uritest1.xsd', dbms_xmlschema.delete_cascade_force );
> 3 end;
> 4 /
> begin
> *
> ERROR at line 1:
> ORA-04020: deadlock detected while trying to lock object
> XDB.XDBdTReGrBbkTgQDiJQPdUOA==
> ORA-06512: at "XDB.DBMS_XMLSCHEMA_INT", line 0
> ORA-06512: at "XDB.DBMS_XMLSCHEMA", line 100
> ORA-06512: at line 2

Sometimes i have to wait several DAYS, before this succeeds

clueless, any help appreciated

Ko vd Sloot
Tilburg University Received on Fri Nov 25 2005 - 07:28:30 CST