PL/SQL (MOSC)

MOSC Banner

The strange behavior of ISSCHEMAVALID member function of XMLTYPE

edited Mar 28, 2012 3:08AM in PL/SQL (MOSC) 7 commentsAnswered
 s
I ran this code

DECLARE
   XMLDOC       XMLTYPE;
   XMLSCHEMA    XMLTYPE;
   SCHEMAURL    VARCHAR2 (256) := 'testcase.xsd';
BEGIN
   BEGIN
      DBMS_XMLSCHEMA.DELETESCHEMA (SCHEMAURL, 4);
   EXCEPTION
      WHEN OTHERS
      THEN
         NULL;
   END;

   -- Test statements here
   XMLSCHEMA :=
      XMLTYPE (
         '<?xml version="1.0" encoding="UTF-8"?>
elementFormDefault="qualified" attributeFormDefault="unqualified">
<xs:element name="root" xdb:defaultTable="ROOT_TABLE">
<xs:complexType>
<xs:sequence>
<xs:element name="child1"/>
<xs:element name="child2"/>
</xs:sequence>
</xs:complexType>
</xs:element>
</xs:schema>
');

--   DBMS_XMLSCHEMA.REGISTERSCHEMA (SCHEMAURL   => SCHEMAURL,
--                                  SCHEMADOC   => XMLSCHEMA,
--                                  LOCAL       => TRUE,
--                                  GENTYPES    => FALSE,

Howdy, Stranger!

Log In

To view full details, sign in to My Oracle Support Community.

Register

Don't have a My Oracle Support Community account? Click here to get started.

Category Leaderboard

Top contributors this month

New to My Oracle Support Community? Visit our Welcome Center

MOSC Help Center