主页 / 问题 / 1163148
Accepted
Vadim Artyushenko
Asked:2020-08-07 15:56:23 +0800 CST2020-08-07 15:56:23 +0800 CST

如何在 PL/SQL 过程中仅将包含 XML 的 CLOB 部分转换为 xmlType？

  • 772

请求与序言一起以CLOВXML 格式存储：

POST:...
Cache-Control: no-cache
Connection: keep-alive
...
SOAPAction: ...


<SOAP-ENV:Envelope xmlns:SOAP-ENV="http://schemas.xmlsoap.org/soap/envelope/">
  <SOAP-ENV:Header>
  </SOAP-ENV:Header>
  <SOAP-ENV:Body>
   ... 
   *тело SOAP-запроса*
   ...
  </SOAP-ENV:Body>
</SOAP-ENV:Envelope>

我正在尝试编写一个我处理的 PL/SQL 过程CLOB，但是xmlТype()有了这些数据，它给出了一个跟踪。错误：

ORA-31011: XML parsing failed
ORA-19202: Error occurred in XML processing
LPX-00210: expected '<' instead of 'P'
Error at line 1
ORA-06512: at "SYS.XMLTYPE", line 272
ORA-06512: at line 1
xml

1 个回答

  1. Best Answer

    试试这样：

    var rc refcursor 
declare 
    result varchar2 (32000); 
    clobval clob := '
POST:...
Cache-Control: no-cache
Connection: keep-alive
...
SOAPAction: ...

<SOAP-ENV:Envelope xmlns:SOAP-ENV="http://schemas.xmlsoap.org/soap/envelope/">
  <SOAP-ENV:Header>
  </SOAP-ENV:Header>
  <SOAP-ENV:Body>
   ... 
   *тело SOAP-запроса*
   ...
  </SOAP-ENV:Body>
</SOAP-ENV:Envelope>'; 
begin
    result := xmlType (regexp_substr (
    dbms_lob.substr (clobval, 32000), '<SOAP-ENV:Envelope.*</SOAP-ENV:Envelope>', 1, 1, 'n')
    ).getStringVal ();
    
    open :rc for select result result from dual;  
end;
/

    结果：

    RESULT
---------------------------------------------------------------------------------
<SOAP-ENV:Envelope xmlns:SOAP-ENV="http://schemas.xmlsoap.org/soap/envelope/">
  <SOAP-ENV:Header>
  </SOAP-ENV:Header>
  <SOAP-ENV:Body>
   ... 
   *тело SOAP-запроса*
   ...
  </SOAP-ENV:Body>
</SOAP-ENV:Envelope>
    • 3

相关问题