ORA-31154 ORA-19202 LPX-249 while Processing XMLDocuments using Datetime, Timestamp Values in Non-English Environment (Doc ID 1355174.1)

Last updated on NOVEMBER 23, 2011

Applies to:

Oracle Server - Enterprise Edition - Version: 11.2.0.2 and later   [Release: 11.2 and later ]
Information in this document applies to any platform.

Symptoms

Processing XML schema based XML documents where XML schema contains datetime and timestamp strings in non-english environment with NLS_NUMERIC_CHARACTERS
= ",." fails with ORA-31154 ORA-19202 LPX-249.

SQL> DECLARE
2
3 vxcouponxmlstring XMLTYPE := XMLType(
4 '<?xml version="1.0" encoding="windows-1252" standalone="yes"?><CouponMetaData >
5 <Coupon CouponId="1" CouponText="CouponText" ValidFrom="2011-07-20T09:52:52" ValidTo="2011-08-25T14:52:52"/>
6 </CouponMetaData>');
7
8 BEGIN
9
10 createCouponMetaData(pixCouponMetaData => vxcouponxmlstring);
11
12 END;
13 /
DECLARE
*
ERROR at line 1:
ORA-31154: invalid XML document
ORA-19202: Error occurred in XML processing
LSX-00249: invalid date or time "2011-07-20T09:52:52,000000"
ORA-06512: at "BUGX.CREATECOUPONMETADATA", line 48
ORA-06512: at line 10

Cause

Sign In with your My Oracle Support account

Don't have a My Oracle Support account? Click to get started

My Oracle Support provides customers with access to over a
Million Knowledge Articles and hundreds of Community platforms