Update – Saving Blob more than 32K using gzip

I thought split and save blob is a great idea until i found the link

http://blogs.microsoft.co.il/blogs/gilf/archive/2009/02/05/back-to-basics-zip-in-net.aspx

Like my grandfather said : Better answer is available if you search for it.

Saving BLOB more than 32K

What method to follow to save a BLOB from .NET to Oracle if the content is more than 32K?

If the content is a string convert the string the Bytes System.Text.

Encoding.ASCII.GetBytes(stringValue)  and Split the Binary to 32k chunks using append logic to add or update

ex: First time calling the chunk insert then update