207: END;
208:
209: -- Now check whether XML schemas are registered
210: begin
211: select count(*) into l_num_schemas from sys.all_xml_schemas
212: where owner = 'ORDSYS'
213: and schema_url in
214: (
215: 'http://xmlns.oracle.com/ord/meta/ordimage',
280: select 'http://xmlns.oracle.com/ord/dicom/UIDdefinition_1_0' schema_url from dual
281: )
282: minus
283: (
284: select schema_url from sys.all_xml_schemas
285: where owner = 'ORDSYS'
286: and schema_url in
287: (
288: 'http://xmlns.oracle.com/ord/meta/ordimage',