Help needed with Registering XSD's in database [message #125531] |
Mon, 27 June 2005 05:22 |
rudid
Messages: 1 Registered: June 2005
|
Junior Member |
|
|
Hello,
I am having diffoculties registering the XSD type_Location in the database (Oracle 9.2.0.5.0) My schema is as follows:
begin dbms_xmlschema.registerSchema('http://devuni06:8081/public/type_StreetName.xsd',
'<schema xmlns="http://www.w3.org/2001/XMLSchema"
targetNamespace="http://devuni06:8081/public/type_StreetName"
elementFormDefault="qualified"
attributeFormDefault="unqualified">
<simpleType name = "type_StreetName">
<restriction base = "string">
<maxLength value = "40"/>
</restriction>
</simpleType>
</schema>',
false, true, false, false); end;
/
begin dbms_xmlschema.registerSchema('http://devuni06:8081/public/type_Locn.xsd',
' <schema
targetNamespace = "http://devuni06:8081/public/type_Locn.xsd"
xmlns:strt = "http://devuni06:8081/public/type_StreetName.xsd"
elementFormDefault = "qualified"
xmlns = "http://www.w3.org/2001/XMLSchema">
<include schemaLocation = "http://devuni06:8081/public/type_StreetName.xsd"/>
<complexType name = "type_Locn">
<sequence>
<element name="STREETNAME" type="strt:type_StreetName"/>
</sequence>
</complexType>
</schema>',
true, true, false, false); end;
/
The error is:
begin dbms_xmlschema.registerSchema('http://devuni06:8081/public/type_Locn.xsd',
*
ERROR at line 1:
ORA-31154: invalid XML document
ORA-19202: Error occurred in XML processing
LSX-00023: unknown namespace URI
"http://devuni06:8081/public/type_StreetName.xsd"
ORA-06512: at "XDB.DBMS_XMLSCHEMA_INT", line 0
ORA-06512: at "XDB.DBMS_XMLSCHEMA", line 12
ORA-06512: at line 1
Any help would be appreciated.
R
|
|
|