oracle 31011,ORA-31011: XML parsing failed

论坛 期权论坛 编程之家     
选择匿名的用户   2021-6-2 16:28   1323   0

Hi.

I parse XML file by the follow sql statements:

--------------------------------------------------------------------------------------------

DECLARE

V_XML_PARSER XMLPARSER.PARSER;

V_REQUEST_DATA CLOB;

BEGIN

V_XML_PARSER := XMLPARSER.NEWPARSER;

SELECT REQUEST_DATA

INTO V_REQUEST_DATA ---GET THE CLOB DATA

FROM APPS.XXXXX

WHERE PROCESS_SN='xxxxxxxxxxx';

XMLPARSER.PARSECLOB(V_XML_PARSER, V_REQUEST_DATA);

END;

---------------------------------------------------------------------------------------------

and it shows the following errors:

ORA-31011: XML parsing failed

ORA-19202: Error occurred in XML processing

LPX-00217: invalid character 189 (U+00BD)

Error at line 1

ORA-06512: at "XDB.DBMS_XMLPARSER", line 191

ORA-06512: at line 12

What causes these errors?

Thanks.

分享到 :
0 人收藏
您需要登录后才可以回帖 登录 | 立即注册

本版积分规则

积分:3875789
帖子:775174
精华:0
期权论坛 期权论坛
发布
内容

下载期权论坛手机APP