Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
![]() |
![]() |
Home -> Community -> Usenet -> c.d.o.misc -> Oracle Lite on Windows XP / Unable to retrieve Blobs>39278 bytes
Hi all
I have a problem around Oracle Lite, C#, and Oracle component Oracle.DataAccess.Lite_w32
When I try to retrieve a blob that is on the mobile client (WIN XP), if this blobs has a length<39278 bytes then it can well be retrieved
But if the blob is greater that 39278 bytes, this source code only retrieves the first 39278 bytes.
Is there a workaround ??? Can this be a bug or a limitation ???
Thank you
Here is the source code (C#/VS.NET2003) :
oraconn.Open(); orar = (OracleDataReader) oracom.ExecuteReader(); orar.Read(); OracleBlob blob = (OracleBlob)orar["CONTENT"]; MessageBox.Show("Blob Len = " + blob.Length.ToString(), "debug"); byte[] byteData = new byte[blob.Length]; long ireadbytes; ireadbytes = blob.GetBytes(0,byteData,0,(int)blob.Length); MessageBox.Show("nb read bytes = " + ireadbytes.ToString()); int ArraySize = byteData.GetUpperBound(0); FileStream fs1 = new FileStream("c:\\temp\\docblobfile.doc", FileMode.OpenOrCreate, FileAccess.Write); fs1.Write(byteData, 0, ArraySize); fs1.Close(); orar.Close(); oraconn.Close(); MessageBox.Show("END OF PROCESSING", "QCOR");Received on Wed Apr 20 2005 - 08:44:07 CDT
![]() |
![]() |