"r" <t> wrote in message news:<bi22pk$fpn6_at_doiweb4.wob.vw.vwg>...
> Hy- wenn I start this procedure:
> PROCEDURE XML_TEST_ALTE IS
> begin dbms_xmlschema.registerschema('test3', '
> <schema xmlns:xs="http://www.w3.org/2001/XMLSchema"
> elementFormDefault="qualified" attributeFormDefault="unqualified">
> <xs:element name="Person">
> <xs:complexType>
> <xs:sequence>
> <xs:element name="Name" type="xs:string"/>
> <xs:element name="Alter" type="xs:unsignedByte"/>
> </xs:sequence>
> </xs:complexType>
> </xs:element>
> </schema>
> ');
> end;
> is my session killed and have errors message:
> 9:51:32 Start Executing PL/SQL block ...
> 9:51:32 Starting execution of PL/SQL block...
> 9:51:36 ORA-01460: Nicht implementierte oder sinnlose Umwandlung gefordert
> 9:51:36 Team Coding options have been refreshed
> 9:51:36 Execution failed: ORA-03113: Unerwartetes Ã?bertragungsende in
> Kommunikation
> 9:51:36 End Executing PL/SQL block
> 9:51:37 Team Coding options have been refreshed
>
> Wenn i start again sql Navigator 4.3 i see this schema with all objects, but
> i cann not delete this schema.
>
> HELP ME!!
>
> Thanks
You should use proper URL when you register your schemas. ORACLE will
take the 'test3' that you pass to dbms_xmlschema.registerschema, but
that is not a good idea. 'test3', instead of the proper *.xsd, becomes
the schema name. I think you messed up something during your testing.
Can you see it in user_xml_schemas? If not, then 'test3' is probably
just a resource, not schema. What happens when you try to delete it
with dbms_xmlschema.deleteschema? If you get an ORA-31000, try
dbms_xdb.deleteresource instead.
Received on Thu Aug 21 2003 - 11:00:57 CDT
