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]

m4s0n501
Written by:

2 Comments

  1. 9/8/2009

    You’ve said “Just a simple script I want to keep for prosperity.” I presume you mean posterity not prosperity!!

    Anyway, thanks for the script.

    Regards,

    Praveen

  2. Marco Gralike
    9/9/2009

    Your right of course ;-)
    Thanks for the hint ! I altered the text.

Comments are closed.