dbms_xmlschema.registerURI ORA-31001: Invalid resource handle or path name

From: ciao_a via DBMonster.com <u14655_at_uwe>
Date: Fri, 07 Oct 2005 10:41:59 GMT
Message-ID: <557a5f260030d@uwe>

 have to register two XSD

exec dbms_xmlschema.registerURI('http://jupiter: 8080/home/VeRT_XML/Connection/connection.xsd', '/home/VeRT_XML/Connection/connection.xsd',local=> TRUE, GENTYPES => TRUE, GENBEAN =>FALSE, GENTABLES=>TRUE); exec dbms_xmlschema.registerURI('http://jupiter: 8080/home/VeRT_XML/Services/services.xsd','/home/VeRT_XML/Services/services. xsd',local=> TRUE, GENTYPES => TRUE, GENBEAN =>FALSE, GENTABLES=>TRUE); the first commend went fine, the second gave:

ERROR at line 1:
ORA-31001: Invalid resource handle or path name "/home/VeRT_XML/Services/services.xsd"

ORA-06512: at "SYS.XDBURITYPE", line 45 
ORA-06512: at "XDB.DBMS_XMLSCHEMA", line 163 
ORA-06512: at line 1 

the path is correct and the XSD are:
services.xsd
<?xml version="1.0" encoding="UTF-8"?>
<xs:schema xmlns:xs="http://www.w3.org/2001/XMLSchema" xmlns:xdb=" http://xmlns.oracle.com/xdb" elementFormDefault="qualified" attributeFormDefault="unqualified">

	<xs:element name="vertxml" xdb:defaultTable="SERVICE_SUB">
		<xs:complexType xdb:SQLType="SERVICE_SUB_TYPE">
			<xs:sequence>


				<xs:element name="obu">

					<xs:complexType>
						<xs:attribute name="id" type="xs:integer" use="required"/>
						<xs:attribute name="date" type="xs:date" use="required"/>
						<xs:attribute name="time" type="xs:time" use="required"/>
						<xs:attribute name="authenticated" type="xs:boolean" use="required"/>
					</xs:complexType>


				</xs:element>

				<xs:element name="services">

					<xs:complexType>
						<xs:sequence>
							<xs:element name="service" minOccurs="0" maxOccurs="unbounded">
								<xs:complexType>
									<xs:attribute name="name" type="xs:string" use="required"/>
									<xs:attribute name="id" type="xs:integer" use="required"/>
								</xs:complexType>
							</xs:element>
						</xs:sequence>
						<xs:attribute name="subscribed" type="xs:boolean" use="required"/>
					</xs:complexType>


				</xs:element>

			</xs:sequence>
			<xs:attribute name="message_type" use="required" fixed="connection_ack">


				<xs:simpleType>

					<xs:restriction base="xs:string"/>


				</xs:simpleType>

			</xs:attribute>
		</xs:complexType>
	</xs:element>
 

and

connection.xsd:

<?xml version="1.0" encoding="UTF-8"?>
<xs:schema xmlns:xs="http://www.w3.org/2001/XMLSchema" xmlns:xdb=" http://xmlns.oracle.com/xdb" elementFormDefault="qualified" attributeFormDefault="unqualified">

	<xs:element name="vertxml" xdb:defaultTable="CONNECTION">
		<xs:complexType xdb:SQLType="CONNECTION_TYPE">
			<xs:sequence>


				<xs:element name="obu">

					<xs:complexType>
						<xs:attribute name="id" type="xs:integer" use="required"/>
						<xs:attribute name="date" type="xs:date" use="required"/>
						<xs:attribute name="time" type="xs:time" use="required"/>
					</xs:complexType>


				</xs:element>

			</xs:sequence>
			<xs:attribute name="message_type" use="required" fixed="connection">


				<xs:simpleType>

					<xs:restriction base="xs:string"/>


				</xs:simpleType>

			</xs:attribute>
		</xs:complexType>
	</xs:element>

</xs:schema> Received on Fri Oct 07 2005 - 05:41:59 CDT