Q

Any way to edit a BLOB?

Is there a way to "edit" a BLOB or export it in an editable format (i.e., JPEG or GIF)? Specifically, I need to rotate an image that was not stored correctly so that it will display properly. The original image file no longer exists.
There is no way to edit a BLOB in SQL*Plus aside from using the DBMS_LOB package. Unfortunately, there is no way to rotate an image with this package. You'll have to pull the image out of the database, store it on disk somewhere, and then use an image processing program to perform the rotation before saving the image back to the database table. How do you pull the image out of the database? The answer all depends on your application platform. Each one is different. This document will give you information for a number of application development platforms.
This was first published in October 2003

Dig deeper on Oracle database design and architecture

Pro+

Features

Enjoy the benefits of Pro+ membership, learn more and join.

Have a question for an expert?

Please add a title for your question

Get answers from a TechTarget expert on whatever's puzzling you.

You will be able to add details on the next page.

0 comments

Oldest 

Forgot Password?

No problem! Submit your e-mail address below. We'll send you an email containing your password.

Your password has been sent to:

-ADS BY GOOGLE

SearchDataManagement

SearchBusinessAnalytics

SearchSAP

SearchSQLServer

TheServerSide

SearchDataCenter

SearchContentManagement

SearchFinancialApplications

Close