| 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
![]() |
![]() |