Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.misc -> Oracle Lite on Windows XP / Unable to retrieve Blobs>39278 bytes

Oracle Lite on Windows XP / Unable to retrieve Blobs>39278 bytes

From: mcode <microcode2004_at_hotmail.com>
Date: 20 Apr 2005 06:44:07 -0700
Message-ID: <480bd64a.0504200544.789966e1@posting.google.com>


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

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US