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)

PL/SQL datatypes in Oracle

Converting Long Raw to Blob

Please create a username to comment.

Developing an enterprise data strategy: 10 steps to take

How graph data science is helping the fight against COVID-19

Okera sees increasing demand for enterprise data governance

OmniSci analytics tools to come embedded in HP workstations

Economic downturn shows businesses true value of analytics

Key differences of a data scientist vs. data engineer

SAP Cloud Platform app helps German citizens find their way home

SAP Business One overview: Features, benefits and more

SAP S/4HANA deployment options: Legacy ERP vs. cloud

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

Compare these top 6 Java IDEs for development

Eclipse launches Theia 1.0 as alternative to VS Code

Developing a COVID-19 application? Design it the right way

Advances in server hardware components speed up data centers

Improvements in CPU features help shape selection

Dive into the quantum computing qubit with IBM's Bob Sutor

Enterprise search software comparison

New OpenText CE apps, services roll out

Box Shield adds malware detection

Food industry turns to AI hiring platform to fill 1M jobs

How companies can use tech to ramp up remote work productivity

H-1B work visa petitions hit record high, despite pandemic

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)

PL/SQL datatypes in Oracle

Converting Long Raw to Blob

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.