I am using XMLType to store data and I get the following error when I try to put more taht about 2000 character into the XMLType:
java.sql.SQLException: ORA-31011: XML parsing failed
ORA-19202: Error occurred in XML processing
LPX-00007: unexpected end-of-file encountered
It seems that if I remove contents from the FleetDescription tag in the xml below until the entire document is less than 2000 character everything works but if the document is over 2000 charecter it fails.
I am using:
Oracle9i Release 9.2.0.1.0 - 64bit Production
JServer Release 9.2.0.1.0 - Production
Here is the XML I am inserting
<?xml version="1.0" encoding="UTF-8"?>
<Data>
<AddedPIP>$ 9</AddedPIP>
<AddedPIPSymbol>$ 10</AddedPIPSymbol>
<ALAEPolicyLimits>Inside</ALAEPolicyLimits>
<AutoMedPay>$ 11</AutoMedPay>
<AutoMedPaySymbol>$ 12</AutoMedPaySymbol>
<BodilyInjury>$ 3</BodilyInjury>
<BodilyInjurySymbol>$ 4</BodilyInjurySymbol>
<CombinedSingleLimit>$ 1</CombinedSingleLimit>
<CombinedSingleLimitSymbol>$ 2</CombinedSingleLimitSymbol>
<CoverageForm>BA</CoverageForm>
<FleetDescription>aaaaaaaaaaaaaa bbbbbbbbbbbbbbbbbbbbbbbbbbb cccccccccccccccccccccccccccc dddddddddddddddddddddddddd eeeeeeeeeeeeeeeeeeeeeeeeee ffffffffffffffffffffffffffffff gggggggggggggggggggggggggggg h hhhhhhhhhhhhhhhhhhhhhhhhhhhh iiiiiiiiiiiiiiiiiiiiiiiiiiiiiiiiiiiiiiiiiiiiiiiii jjjjjjjjjjjjjjjjjjjjjjjjjjjjjj kkkkkkkkkkkkkkkkkkkkkkkkkkkkkkkkkkkk lllllllllllllllllllllllllllllllllllllllllllllllllllllll mmmmmmmmmmmmmmmmm nnnnnnnnnnnnnnnnnnnnnnnnnnnnnnnn ooooooooooooooooooooooo ppppppppppppppppppppppppp qqqqqqqqqqqqqqqqqqqqqqqqqqqqq rrrrrrrrrrrrrrrrrrrrrrrrrrrrrrrrrrrrrr sssssssssssssssssssssssssssssssssssssssss ttttttttttttttttttttttttttttttttttttttt uuuuuuuuuuuuuuuuuuuuuuuuuuuuuuuuu rrrrrrrrrrrrrrrrrrrrrrrrrrrrrrrrrrr vvvvvvvvvvvvvvvvvvvvvvvvvvvvvvvvvvvvvvvvvvvvvvvvvvvvvvvvvvvvvvvvvvv wwwwwwwwwwwwwwwwwwwwwwww xxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxx yyyyyyyyyyyyyyyyyyyyyyyyy zzzzzzzzzzzzzzzzzzzzzzzz</FleetDescription>
<HasAuto>on</HasAuto>
<InsuredCoverageType>N/A - Guaranteed Cost</InsuredCoverageType>
<MVROnFile>Yes</MVROnFile>
<OtherComments>aaaaaaaaaaaaaa bbbbbbbbbbbbbbbbbbbbbbbbbbb cccccccccccccccccccccccccccc dddddddd</OtherComments>
<ParticipationValue>17</ParticipationValue>
<PIP>$ 7</PIP>
<PIPSymbol>$ 8</PIPSymbol>
<PropertyDamage>$ 5</PropertyDamage>
<PropertyDamageSymbol>$ 6</PropertyDamageSymbol>
<SafetyProgram>No</SafetyProgram>
<UnderinsuredMotorist>$ 15</UnderinsuredMotorist>
<UnderinsuredMotoristSymbol>$ 16</UnderinsuredMotoristSymbol>
<UninsuredMotorist>$ 13</UninsuredMotorist>
<UninsuredMotoristSymbol>$ 14</UninsuredMotoristSymbol>
</Data>