HOWTO: Compile a XML Schema in XMLDB

Just a simple script I want to keep for posterity. The foundations were laid by Mark Drake.

-- --------------------------------------------------------
--
-- Author     : Mark Drake
-- Purpose    : Compiling XML Schema
--
-- Altered    : Marco Gralike
-- Date       : 09/02/2007
-- Alteration : Different error handling
-- 
--
-- --------------------------------------------------------
SET echo ON 
 
-- spool compileSchemas.log 
-- connect &USERNAME/&PASSWORD 
-- set serveroutput on 
-- 
 
DECLARE 
 
cursor getSchemaList IS 
  SELECT schema_url 
  FROM user_xml_schemas; 
 
BEGIN 
 
FOR schema IN getSchemaList 
loop 
  BEGIN 
    dbms_output.put_line('Processing : ' || schema.schema_url); 
    dbms_xmlschema.compileSchema(schema.schema_url); 
    dbms_output.put_line('Compiled'); 
  exception WHEN others THEN 
    dbms_output.put_line('Failed ('||SQLCODE||'): ' ||SQLERRM); 
  END; 
END loop; 
END; 
/ 
 
-- --------------------------------------------------------

The “Invalid XDB schema – how to identify?” part, can be found in the following OTN XMLDB Forum Thread [here]