blog.gralike.com

-- --------------------------------------------------------
--
-- 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; 
/ 
 
-- --------------------------------------------------------