Problem solve Get help with specific problems with your technologies, process and projects.

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 last published in October 2003

Dig Deeper on Oracle database design and architecture

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.

Start the conversation

Send me notifications when other members comment.

By submitting you agree to receive email from TechTarget and its partners. If you reside outside of the United States, you consent to having your personal data transferred to and processed in the United States. Privacy

Please create a username to comment.