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 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

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
  Cause
  Solution
  References

This document is being delivered to you via Oracle Support's Rapid Visibility (RaV) process and therefore has not been subject to an independent technical review.

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