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): 57168/ 74

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:

  1. Execute an insert SQL statement against an Oracle database.
  2. Saving image data to the database.
  3. 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

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).






Community Advice: ASP | SQL | XML | Regular Expressions | Windows


©Copyright 1998-2024 ASPAlliance.com  |  Page Processed at 2024-03-19 5:46:49 AM  AspAlliance Recent Articles RSS Feed
About ASPAlliance | Newsgroups | Advertise | Authors | Email Lists | Feedback | Link To Us | Privacy | Search