Storing images in an Oracle database

Brian Peasland

Published: 03 May 2005

How can I store images in an Oracle database directly from a scanner? I used a form to view the image after scanned it, and now I want to insert it directly into my database.

To store your binary images in an Oracle database, you will need to create a column in your table defined with the BLOB datatype. BLOB stands for Binary Large Object. Images from scanners, mpeg files, movie files and so on can all be stored in the BLOB column. An example of creating a table with a BLOB column can be seen below:

CREATE TABLE test_table (
   id NUMBER,
   image BLOB);

The trick now is get your application to store the image in the table. The Oracle Application Developer's Guide -- Large Objects contains step-by-step examples for PL/SQL, OCI and Pro*C application development platforms.

If you are using Oracle Forms as your development platform, then there are two functions in Forms that are of interest...

Step 2 of 2:

You forgot to provide an Email Address.

This email address doesn’t appear to be valid.

This email address is already registered. Please login.

You have exceeded the maximum character limit.

Please provide a Corporate E-mail Address.
- I agree to TechTarget’s Terms of Use, Privacy Policy, and the transfer of my information to the United States for processing to provide me with relevant information as described in our Privacy Policy.
Please check the box if you want to proceed.
- I agree to my information being processed by TechTarget and its Partners to contact me via phone, email, or other means regarding information relevant to my professional interests. I may unsubscribe at any time.
Please check the box if you want to proceed.

to you, READ_IMAGE_FILE and WRITE_IMAGE_FILE. Rather than reinvent the wheel, I'll send you to one of the best resources around, AskTom.

Aster Data founders explain unified approach to data, big and small

Working with binary large objects (BLOBs)

Converting Long Raw to Blob

Retrieve images from SQL Server and store in VB.Net

Please create a username to comment.

Top 7 data catalog use cases for enterprises

Metamorphosis of Kafka Confluent event streaming technologies

Isima emerges with bi(OS) converged data platform

Baseball's Twins deploy Databricks to improve analytics power

Maine state government modernizes with Oracle Analytics

TigerGraph adds cloud support, helps standardize graph coding

SAP S/4HANA Cloud interest increasing

Penn State graduates from legacy ERP to SAP S/4HANA

ASUG/DSAG members like S/4HANA, but implementations still lag

SQL Server database design best practices and tips for DBAs

SQL Server in Azure database choices and what they offer users

Using a LEFT OUTER JOIN vs. RIGHT OUTER JOIN in SQL

Reduced cost, responsive apps from micro front-end architecture

How Quarkus fits into the Red Hat Runtimes formula

3 ways a volunteer programmer can help in a pandemic

The case against data center consolidation

Big Blue ties its IBM Z Series tighter to hybrid clouds

A mechanical refrigeration system primer for admins

Consider these electronic signature best practices

What the CCPA means for content security

Microsoft Lists app replaces some SharePoint functionality

4 ways HR and IT can collaborate on employee experience

Digital adoption platforms can improve employee experience

The HR software buying team: Roles, responsibilities, tips

Dig Deeper on Oracle database backup and recovery

Aster Data founders explain unified approach to data, big and small

Working with binary large objects (BLOBs)

Converting Long Raw to Blob

Retrieve images from SQL Server and store in VB.Net

Related Q&A from Brian Peasland

Start the conversation

0 comments

Register

Login

Forgot your password?

Your password has been sent to:

Please create a username to comment.