How to write a file into Blob column using ODP.NET

  • Thread starter Thread starter Guest
  • Start date Start date
Mahesh said:
Hi All,

I checked the Knowledge Base article 317043, "HOW TO: Read and Write a File
to and from a BLOB Column by Using Chunking in ADO.NET and Visual C# .NET,"
at http://support.microsoft.com/default.aspx?scid=kb;en-us;317043.

But it explains only for sql server, does anyone have a sample on how to
achieve the same using ODP.
Click to expand...

1) read file into byte array
2) pass byte array as value for parameter of type Blob
3) exec an insert query using the parameter you passed of type blob
4) done! :)

FB

--
 
Hi Frans,

If I create a byteArray and pass as a parameter, that byte array is still
going hold the same memory of the file size.

My question is if i need to insert a 50 MB file from ASP.NET to Oracle DB as
a blob object. If i do it in chunks then i will consume only less memory.

Regards
Mahesh
 
Back
Top