Database Software

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

Can we load any xml into xmltype table with out XSD?

459978Feb 22 2010 — edited Feb 24 2010

Hi,
Can we load any xml into xmltype table with out any xsd, I tried to register XSD but it gave me some exceptions.
for reference here i am pasting my code.

BEGIN
DBMS_XMLSCHEMA.registerSchema(
SCHEMAURL => 'http://www.w3.org/2001/XMLSchema',
SCHEMADOC => bfilename('EHE_DBINBOUND','MetInvML.xsd'));
END;

Error report:
ORA-31011: XML parsing failed
ORA-19202: Error occurred in XML processing
LPX-00104: Warning: element "xsd:schema" is not declared in the DTD
Error at line 69
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
31011. 00000 - "XML parsing failed"

Locked Post

New comments cannot be posted to this locked post.

Locked on Mar 24 2010

Added on Feb 22 2010

#performance-availability, #xml-db

2 comments

1,910 views