vb.net - Corrupt string when writing to Oracle DB -
I'm serializing some data for XML, then writing output to an Oracle DB.
The serial data can be very long and is writing for a long pillar type (it will never reach the maximum value of long, which is something like 32,000 characters)
Sometimes when your data is written, it appears to corrupt and just "?" Display and many other control characters, sometimes write works perfectly.
The function I always give XML with no problem, the problem occurs when the data is written.
This is my serializer function:.
Private function in sequence (in the form of myObject object) // a string ... dim x = new System.xml.Serialization.XmlSerializer (to myObject object to object [GetType] ()) String stringWriter = New stringWriter () x.Serialize (stringWriter, myObject) Dim test = stringWriter.ToString () return stringWriter.ToString () stringWriter.Close () termination function Then I am writing the data that I am returning the DHB using the NHBnet, I will not include this code because it is too long and I Sector has failed without time. The problem is that Oracle data is happening with the way to interpret
My unitofwork does without any errors - .. Just data is corrupted when Oracle receives it
Update If I copy the stringwriter output, then column I have a problem in the database
As advised by wol เคนै I? In the comment,
was set for it CLOB was not present in the column data type as XMLType in my version of Oracle.
Comments
Post a Comment