Devart Forums

I am trying to store a large XML-string in a Oracle database field of type XMLType, using the Entity Framework. When I try to store small XML-strings in this field, everything works fine. When I try to store a large XML-string however, I get the following error message:

CoreLab.Oracle.OracleException: ORA-31011: XML parsing failed
ORA-19202: Error occurred in XML processing
LPX-00007: unexpected end-of-file encountered

It looks like only part of the XML is passed into the XMLType field, which causes the exceptions. Does anybody know if there is a limitation to the size of a string you can store using CoreLab.Oracle? If so, is there a way to change this?

Thanks in advance,
Bas

Can you please tell us the size of your XML-string when this exception arises? We will try to reproduce the error.

The size of the XML-string I am trying to save is 439908 of length.

I have done some other small tests to find out at which size errors occur. It looks like I can't insert XML-strings with a length bigger than 4000. When I try to insert a string slightly bigger than 4000, I get a different error message:
"ORA-01461: can bind a LONG value only for insert into a LONG column"

When the size of the XML-string is bigger than 8000 I get the error I initially posted.

We are investigating this problem. You will be notified as soon as possible.

Shalex, can you give me an update of the status of the investigation of this problem? Thanks in advance!
Bas

The problem is fixed. Look forward to the next build that will be available in several days.

The new build of OraDirect .NET version 4.75.43 is available!
Please visit http://www.devart.com/forums/viewtopic.php?t=12982