My Oracle Support Banner

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

Last updated on FEBRUARY 26, 2019

Applies to:

Oracle Database - Enterprise Edition - Version 11.2.0.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

Changes

 

Cause

To view full details, sign in with your My Oracle Support account.

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


In this Document
Symptoms
Changes
Cause
Solution
References


My Oracle Support provides customers with access to over a million knowledge articles and a vibrant support community of peers and Oracle experts.