Database Software

Hi there,
do you know if there is any chance to successfully register the DTD for XHTML using function DBMS_XMLSCHEMA.registerUri in ORACLE XE?

When i try to execute the following code:

BEGIN
  DBMS_XMLSCHEMA.registerURI(
    SCHEMAURL => 'http://www.w3.org/1999/xhtml',
    SCHEMADOCURI => 'http://www.w3.org/TR/xhtml1/DTD/xhtml1-transitional.dtd',
    LOCAL => FALSE,
    GENTYPES => FALSE, 
    GENTABLES => FALSE);
END;
/

i get:

ORA-31011: XML parsing failed
ORA-19202: Error occurred in XML processing
LPX-00247: invalid Document Type Declaration (DTD)
Error at line 26
ORA-06512: at "XDB.DBMS_XMLSCHEMA_INT", line 37
ORA-06512: at "XDB.DBMS_XMLSCHEMA", line 61
ORA-06512: at "XDB.DBMS_XMLSCHEMA", line 126
ORA-06512: at line 2

Initially i thought it was a problem of with the included documents like "xhtml-lat1.ent", so i downloaded all these components into a local directory and attempted to register the DTD again using the following code:

BEGIN
  DBMS_XMLSCHEMA.registerSchema(
    SCHEMAURL => 'http://www.w3.org/1999/xhtml',
    SCHEMADOC => bfilename('XMLDIR','xhtml1-transitional.dtd'),
    CSID => nls_charset_id('AL32UTF8'),
    LOCAL => FALSE,
    GENTYPES => FALSE, 
    GENTABLES => FALSE);
END;
/

however i am getting the same error LPX-00247.

If i execute

alter session set events='31156 trace name context forever, level 2'

i can skip the validation, however if the file contains an entity like   the parser fails with

LPX-00226: entity "nbsp" is not declared

Any ideas on how to move forward remaining on Oracle XE ?

Thanks,
Flavio
---------------------------------------
http://oraclequirks.blogspot.com