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
Store large XML strings using Entity Framework
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.
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.
The new build of OraDirect .NET version 4.75.43 is available!
Please visit http://www.devart.com/forums/viewtopic.php?t=12982
Please visit http://www.devart.com/forums/viewtopic.php?t=12982