Oracle 验证XML文件问题

askTom 2017-03-30

282

问题描述

你好，

我有一个验证xml文件的问题。
要验证的所有XSD文件和xml文件的链接在这里:
https://www.vmi.lt/cms/documents/10162/6703244/SPECIFIKACIJA_MAI_55.zip/c86d3e1d-b081-47d6-a9a1-b021f6dcc85c

我已经在Oracle中注册了架构并检查了结果0 (架构不匹配XSD)
然后我使用XMLSPY和记事本插件来检查，结果是文件有效。
唯一需要做的就是替换M55TypesSti_v0。1。xsd与M55TypesSti_v0。2。xsd

我使用Oracle的代码 (文件中的数据要粘贴到这里很大，但是很容易从上面的链接直接从zip文件中粘贴)

DECLARE
  l_Clob CLOB;
  l_Xml XMLTYPE := XMLTYPE(...); -- Copied file from /XML pavyzdžiai/MAI55_SLIK_XML_v01.xml
-- !!! M55TypesSti_v0.1。xsd inside this file was changed to M55TypesSti_v0.2。xsd
BEGIN
-- Because file file /MAI_55_LT_XSD-v0.2/M55TypesSti_v0.2。xsd is to big for VARCHAR2 datatype so I used
-- Dbms_Lob.Append(l_Clob, ...) But maybe will be easier for you to load file from disk...

  Dbms_XmlSchema.RegisterSchema('CommonTypesSti_v0.2。xsd', ...); -- Copied file body from /MAI_55_LT_XSD-v0.2/CommonTypesSti_v0.2。xsd
  Dbms_XmlSchema.RegisterSchema('IsoTypesSti_v0.2。xsd', ...); -- Copied file body from /MAI_55_LT_XSD-v0.2/IsoTypesSti_v0.2。xsd
  Dbms_XmlSchema.RegisterSchema('M55TypesSti_v0.2。xsd', l_Clob);
  Dbms_XmlSchema.RegisterSchema('CommonTypesSti_v0.2。xsd', ...); -- Copied file body from /MAI_55_LT_XSD-v0.2/CommonTypesSti_v0.2。xsd

  Dbms_Output.Put_Line(l_Xml.isSchemaValid('M55slik_v0.2')); -- returns 0
END;
复制