Read and Write BLOB Data to a Database Table with ODP.NET: ASP Alliance

Print Add To Favorites Email To Friend Rate This Article
Read and Write BLOB Data to a Database Table with ODP.NET

page 1 of 7

Published: 27 Dec 2004

Unedited - Community Contributed

Abstract
By utilizing ODP.NET, Oracle database, and really very little effort you also can store images as a Blob for convenient storage and simple categorization.

by Steven Swafford
Feedback

Average Rating:

Views (Total / Last 10 Days): 55452/ 144

Article Contents:

Read and write BLOB data to a database introduction

[ Download Code ]

Objective:

The purpose of this article is to provide the mechanism to accomplish the following:

Execute an insert SQL statement against an Oracle database.
Saving image data to the database.
Writing image data to a file from the database.

Prerequisites:

You should be familiar with an IDE such as Visual Studio .NET or equivalent. While such an IDE is not required it does make development efforts much easier. Also you should possess an understanding of ODP.NET and databases. In this case since we are using ODP.NET all further references to the database will be implied as an Oracle database.

Now that I have discussed to objective and prerequisites we will now move on to establishing the database schema related to this article.

View Entire Article

(Page 2) »

User Comments

Title: Read/Write BLOB data when file > 32K
Name: Roger Rowe
Date: 2005-03-07 1:03:00 PM
Comment:
Go see this article:
http://support.microsoft.com/default.aspx?scid=kb;en-us;322796
This shows you how to insert larger data - your version will die for data larger than 32K - a PLSQL limitation).