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

[Guest]

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.

Regards
Mahesh

 

[Frans Bouma [C# MVP]]

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.

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

--

 

[Guest]

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