SQL> /*
DOC>
DOC>    The URL here is simply a name that uniquely identifies the registered XML schema
DOC>    within the database and need not be the physical URL at the which the XML schema
DOC>    document is located.
DOC>
DOC>    dbms_xmlschema.registerSchema(schemaURL,......)
DOC>    schemaURL is the URL that uniquely identifies the schema document.
DOC>    This value is used to derive the path name of the schema document within the
DOC>    XDB hierarchy.
DOC>
DOC>*/
SQL> 
SQL> exec dbms_xmlschema.deleteschema('http://www.w3.org/2001/XMLSchema', dbms_xmlschema.delete_cascade_force);

PL/SQL procedure successfully completed.

SQL> exec dbms_xmlschema.deleteschema('c:/xml_test/xml.xsd', dbms_xmlschema.delete_cascade_force);

PL/SQL procedure successfully completed.

SQL> 
SQL> -- Can not use back slash
SQL> declare
  2          doc varchar2(1000) := '
  3  <schema
  4  targetNamespace="C:\xml_test\xml.xsd"
  5  xmlns:po="C:\xml_test\xml.xsd"
  6  xmlns="C:\xml_test\XMLSchema">
  7  </schema>';
  8  begin
  9    dbms_xmlschema.registerSchema('c:\xml_test\xml.xsd', doc);
 10  end;
 11  /
declare
*
ERROR at line 1:
ORA-31020: The operation is not allowed, Reason: invalid characters in path 
name 
ORA-06512: at "XDB.DBMS_XMLSCHEMA_INT", line 0 
ORA-06512: at "XDB.DBMS_XMLSCHEMA", line 12 
ORA-06512: at line 9 


SQL> 
SQL> -- Does not like this either
SQL> declare
  2          doc varchar2(1000) := '
  3  <schema
  4  targetNamespace="C:\\xml_test\\xml.xsd"
  5  xmlns:po="C:\\xml_test\\xml.xsd"
  6  xmlns="C:\\xml_test\\XMLSchema">
  7  </schema>';
  8  begin
  9    dbms_xmlschema.registerSchema('c:\\xml_test\\xml.xsd', doc);
 10  end;
 11  /
declare
*
ERROR at line 1:
ORA-31020: The operation is not allowed, Reason: invalid characters in path 
name 
ORA-06512: at "XDB.DBMS_XMLSCHEMA_INT", line 0 
ORA-06512: at "XDB.DBMS_XMLSCHEMA", line 12 
ORA-06512: at line 9 


SQL> 
SQL> declare
  2          doc varchar2(1000) := '
  3  <schema
  4  targetNamespace="C:/xml_test/xml.xsd"
  5  xmlns:po="C:/xml_test/xml.xsd"
  6  xmlns="C:/xml_test/XMLSchema">
  7  </schema>';
  8  begin
  9    dbms_xmlschema.registerSchema('c:/xml_test/xml.xsd', doc);
 10  end;
 11  /

PL/SQL procedure successfully completed.

SQL> select * from resource_view where any_path like '%xml_test%';

RES                                                                             
--------------------------------------------------------------------------------
ANY_PATH                                                                        
--------------------------------------------------------------------------------
<Resource>                                                                      
  <CreationDate>2003-08-18T16:44:12.835000000</CreationDate>                    
  <ModificationDate>2003-08-18T16:44:12.835000000</ModificationDate>            
  <DisplayName>xml_test</DisplayName>                                           
  <Language>us english</Language>                                               
  <CharacterSet>utf-8</CharacterSet>                                            
  <ContentType>text/plain</ContentType>                                         
  <RefCount>1</RefCount>                                                        
</Resource>                                                                     
/sys/schemas/JYANG/c:/xml_test                                                  
                                                                                
<Resource>                                                                      
  <CreationDate>2003-08-21T09:06:06.552000000</CreationDate>                    
  <ModificationDate>2003-08-21T09:06:06.552000000</ModificationDate>            
  <DisplayName>xml.xsd</DisplayName>                                            
  <Language>us english</Language>                                               
  <CharacterSet>utf-8</CharacterSet>                                            
  <ContentType>text/xml</ContentType>                                           
  <RefCount>1</RefCount>                                                        
</Resource>                                                                     
/sys/schemas/JYANG/c:/xml_test/xml.xsd                                          
                                                                                

SQL> select * from path_view where path like '%xml_test%';

PATH                                                                            
--------------------------------------------------------------------------------
RES                                                                             
--------------------------------------------------------------------------------
LINK                                                                            
--------------------------------------------------------------------------------
/sys/schemas/JYANG/c:/xml_test                                                  
<Resource>                                                                      
  <CreationDate>2003-08-18T16:44:12.835000000</CreationDate>                    
  <ModificationDate>2003-08-18T16:44:12.835000000</ModificationDate>            
  <DisplayName>xml_test</DisplayName>                                           
  <Language>us english</Language>                                               
  <CharacterSet>utf-8</CharacterSet>                                            
  <ContentType>text/plain</ContentType>                                         
  <RefCount>1</RefCount>                                                        
</Resource>                                                                     
<LINK xmlns="http://xmlns.oracle.com/xdb/XDBStandard">                          
  <ParentName>c:</ParentName>                                                   
  <ChildName>xml_test</ChildName>                                               
  <Name>xml_test</Name>                                                         
  <Flags>AAAABA==                                                               
                                                                                
</Flags>                                                                        
  <ParentOid>2HQXMbJuRoqrSU2wKv03rA==                                           
                                                                                
</ParentOid>                                                                    
  <ChildOid>kLdTUskxQ+WZVzIeABT5TA==                                            
                                                                                
</ChildOid>                                                                     
</LINK>                                                                         
                                                                                
/sys/schemas/JYANG/c:/xml_test/xml.xsd                                          
<Resource>                                                                      
  <CreationDate>2003-08-21T09:06:06.552000000</CreationDate>                    
  <ModificationDate>2003-08-21T09:06:06.552000000</ModificationDate>            
  <DisplayName>xml.xsd</DisplayName>                                            
  <Language>us english</Language>                                               
  <CharacterSet>utf-8</CharacterSet>                                            
  <ContentType>text/xml</ContentType>                                           
  <RefCount>1</RefCount>                                                        
</Resource>                                                                     
<LINK xmlns="http://xmlns.oracle.com/xdb/XDBStandard">                          
  <ParentName>xml_test</ParentName>                                             
  <ChildName>xml.xsd</ChildName>                                                
  <Name>xml.xsd</Name>                                                          
  <Flags>AAAAAA==                                                               
                                                                                
</Flags>                                                                        
  <ParentOid>kLdTUskxQ+WZVzIeABT5TA==                                           
                                                                                
</ParentOid>                                                                    
  <ChildOid>eDfOB+vBRom9j2eDhetJPg==                                            
                                                                                
</ChildOid>                                                                     
</LINK>                                                                         
                                                                                

SQL> select SCHEMA_URL from user_xml_schemas;

SCHEMA_URL                                                                      
--------------------------------------------------------------------------------
http://www.example.com/schemas/ipo.xsd                                          
c:/xml_test/xml.xsd                                                             

SQL> exec dbms_xmlschema.deleteschema('c:/xml_test/xml.xsd', dbms_xmlschema.delete_cascade_force);

PL/SQL procedure successfully completed.

SQL> 
SQL> begin
  2  dbms_xmlschema.registerschema('test3/xml.xsd', '
  3  <schema xmlns:xs="http://www.w3.org/2001/XMLSchema"
  4  elementFormDefault="qualified" attributeFormDefault="unqualified">
  5  <xs:element name="Person">
  6  <xs:complexType>
  7  <xs:sequence>
  8  <xs:element name="Name" type="xs:string"/>
  9  <xs:element name="Alter" type="xs:unsignedByte"/>
 10  </xs:sequence>
 11  </xs:complexType>
 12  </xs:element>
 13  </schema>
 14  ');
 15  end;
 16  /

PL/SQL procedure successfully completed.

SQL> -- 2 resources created: the test3 folder and the schema file
SQL> select path from path_view where path like '%test3%';

PATH                                                                            
--------------------------------------------------------------------------------
/sys/schemas/JYANG/test3                                                        
/sys/schemas/JYANG/test3/xml.xsd                                                

SQL> exec dbms_xmlschema.deleteschema('test3/xml.xsd', dbms_xmlschema.delete_cascade_force);

PL/SQL procedure successfully completed.

SQL> -- Delete the schema will not remove the folder that was created
SQL> select path from path_view where path like '%test3%';

PATH                                                                            
--------------------------------------------------------------------------------
/sys/schemas/JYANG/test3                                                        

SQL> call dbms_xdb.deleteresource('/sys/schemas/JYANG/test3');

Call completed.

SQL> select path from path_view where path like '%test3%';

no rows selected

SQL> 
SQL> begin
  2  dbms_xmlschema.registerschema('test3', '
  3  <schema xmlns:xs="http://www.w3.org/2001/XMLSchema"
  4  elementFormDefault="qualified" attributeFormDefault="unqualified">
  5  <xs:element name="Person">
  6  <xs:complexType>
  7  <xs:sequence>
  8  <xs:element name="Name" type="xs:string"/>
  9  <xs:element name="Alter" type="xs:unsignedByte"/>
 10  </xs:sequence>
 11  </xs:complexType>
 12  </xs:element>
 13  </schema>
 14  ');
 15  end;
 16  /

PL/SQL procedure successfully completed.

SQL> select * from path_view where path like '%test3%';

PATH                                                                            
--------------------------------------------------------------------------------
RES                                                                             
--------------------------------------------------------------------------------
LINK                                                                            
--------------------------------------------------------------------------------
/sys/schemas/JYANG/test3                                                        
<Resource>                                                                      
  <CreationDate>2003-08-21T09:06:10.943000000</CreationDate>                    
  <ModificationDate>2003-08-21T09:06:10.943000000</ModificationDate>            
  <DisplayName>test3</DisplayName>                                              
  <Language>us english</Language>                                               
  <CharacterSet>utf-8</CharacterSet>                                            
  <ContentType>text/xml</ContentType>                                           
  <RefCount>1</RefCount>                                                        
</Resource>                                                                     
<LINK xmlns="http://xmlns.oracle.com/xdb/XDBStandard">                          
  <ParentName>JYANG</ParentName>                                                
  <ChildName>test3</ChildName>                                                  
  <Name>test3</Name>                                                            
  <Flags>AAAAAA==                                                               
                                                                                
</Flags>                                                                        
  <ParentOid>QDl6pypjQIm2yRWtBoxEXg==                                           
                                                                                
</ParentOid>                                                                    
  <ChildOid>ZMrzUm9XT/S0UL4LkNfR8Q==                                            
                                                                                
</ChildOid>                                                                     
</LINK>                                                                         
                                                                                

SQL> select SCHEMA_URL from user_xml_schemas;

SCHEMA_URL                                                                      
--------------------------------------------------------------------------------
http://www.example.com/schemas/ipo.xsd                                          
test3                                                                           

SQL> exec dbms_xmlschema.deleteschema('test3', dbms_xmlschema.delete_cascade_force);

PL/SQL procedure successfully completed.

SQL> 
SQL> 
SQL> declare
  2          doc varchar2(1000) := '
  3  <schema
  4  targetNamespace="http://www.w3.org/2001/XMLSchema"
  5  xmlns:po="http://www.w3.org/2001/XMLSchema"
  6  xmlns="http://www.w3schools.com">
  7  </schema>';
  8  begin
  9    dbms_xmlschema.registerSchema('http://www.w3.org/2001/XMLSchema',doc);
 10  end;
 11  /

PL/SQL procedure successfully completed.

SQL> select * from resource_view where any_path like '%XMLSchema%';

RES                                                                             
--------------------------------------------------------------------------------
ANY_PATH                                                                        
--------------------------------------------------------------------------------
<Resource>                                                                      
  <CreationDate>2003-08-21T09:06:12.239000000</CreationDate>                    
  <ModificationDate>2003-08-21T09:06:12.239000000</ModificationDate>            
  <DisplayName>XMLSchema</DisplayName>                                          
  <Language>us english</Language>                                               
  <CharacterSet>utf-8</CharacterSet>                                            
  <ContentType>text/xml</ContentType>                                           
  <RefCount>1</RefCount>                                                        
</Resource>                                                                     
/sys/schemas/JYANG/www.w3.org/2001/XMLSchema                                    
                                                                                

SQL> select * from path_view where path like '%XMLSchema%';

PATH                                                                            
--------------------------------------------------------------------------------
RES                                                                             
--------------------------------------------------------------------------------
LINK                                                                            
--------------------------------------------------------------------------------
/sys/schemas/JYANG/www.w3.org/2001/XMLSchema                                    
<Resource>                                                                      
  <CreationDate>2003-08-21T09:06:12.239000000</CreationDate>                    
  <ModificationDate>2003-08-21T09:06:12.239000000</ModificationDate>            
  <DisplayName>XMLSchema</DisplayName>                                          
  <Language>us english</Language>                                               
  <CharacterSet>utf-8</CharacterSet>                                            
  <ContentType>text/xml</ContentType>                                           
  <RefCount>1</RefCount>                                                        
</Resource>                                                                     
<LINK xmlns="http://xmlns.oracle.com/xdb/XDBStandard">                          
  <ParentName>2001</ParentName>                                                 
  <ChildName>XMLSchema</ChildName>                                              
  <Name>XMLSchema</Name>                                                        
  <Flags>AAAAAA==                                                               
                                                                                
</Flags>                                                                        
  <ParentOid>oTp5nQ6wRd2u0rZ03J4qTg==                                           
                                                                                
</ParentOid>                                                                    
  <ChildOid>aaCXAGUnTU6Vs6UFlSRpiQ==                                            
                                                                                
</ChildOid>                                                                     
</LINK>                                                                         
                                                                                

SQL> exec dbms_xmlschema.deleteschema('http://www.w3.org/2001/XMLSchema', dbms_xmlschema.delete_cascade_force);

PL/SQL procedure successfully completed.

SQL> spool off