SQL/XML

[huchen]

Hello,

I am exploring SQL/XML in 10g. I found this article is very helpful for me:

http://www.oracle.com/technology/pub/articles/quinlan-xml.html

So I followed the instruction and practice on my local machine(local personal 10g database).

It workded fine until I got stuck here:

BEGIN
DBMS_XMLSCHEMA.registerSchema(
SCHEMAURL => '

http://xmlns.oracle.com/xdb/invoiceformtest.xsd',

SCHEMADOC => bfilename('XMLDIR','invoiceformtest.xsd'),
CSID => nls_charset_id('AL32UTF8'));
END;
/


Here is the error I got:
ERROR at line 1:
ORA-31011: XML parsing failed
ORA-19202: Error occurred in XML processing
LPX-00243: element attribute value must be enclosed in quotes
Error at line 2
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

I am new to SQL/XML and really want to make the example work so I might be able to use this feature somewhere else.

Could you please help me out?

Thank you very much.

 

[huchen]

my data base is
Personal Oracle Database 10g Release 10.2.0.1.0 - Production With the Partitioning, OLAP and Data Mining option

 

[huchen]

Hello, I got answer from Oracle metalink, it says that "the schema document is not well formed". and the document is fixed now.

Thank you very much. this can be closed.