Extract Image from BLOB OBJ in Oracle database table

13 次查看（过去 30 天）
Sean Lawson
Sean Lawson 2011-9-1
评论： Mustafa Zendaki 2021-3-16
Hi All,
I have a oracle database with tables in it. Some of the tables have fields of (BLOB), I know that these BLOBS contain pure jpeg image.
I can export the data in BLOB as matrices by MATLAB, these matrices are all one column matrices as I expected. However, what I really need to do is to have the .jpg image output. Does anyone have any idea how I could do this in MATLAB?
  1 个评论
Mustafa Zendaki
Mustafa Zendaki 2021-3-16
can you please share the code of how you exported he blob into matlab, i would really appreciate it

请先登录，再进行评论。

请先登录，再回答此问题。

回答（2 个）

Walter Roberson
Walter Roberson 2011-9-1
If you want to display the image, you will have to write it to a file and use imread() .
There might be an undocumented method, or perhaps a JAVA method, of converting the byte stream in to an image array, but there is no documented MATLAB routine for doing this.
  1 个评论
Sean Lawson
Sean Lawson 2011-9-1
Thank you.
I do know there are some approaches in .NET, or SQL for example. But I am not sure that if matlab could do this, I do try to find some hints online but there's little. Could you tell me a little bit more?

请先登录，再进行评论。

Aleksy Barski
Aleksy Barski 2018-4-6
编辑：Aleksy Barski 2018-4-6
function [ image ] = deserializeImage( blob )
obj = blob{1,1};
is = obj.getBinaryStream();
bufferedImage = javax.imageio.ImageIO.read(is);
H = bufferedImage.getHeight;
W = bufferedImage.getWidth;
B = uint8(zeros([H,W,3]));
pixelsData = uint8(bufferedImage.getData.getPixels(0,0,W,H,[]));
for i = 1 : H
base = (i-1)*W*3+1;
B(i,1:W,:) = deal(reshape(pixelsData(base:(base+3*W-1)),3,W)');
end
image = B;
clear bufferedImage;
clear is;
end

类别

在 Help Center 和 File Exchange 中查找有关 Read, Write, and Modify Image 的更多信息

标签

Community Treasure Hunt

Find the treasures in MATLAB Central and discover how the community can help you!

Start Hunting!

Translated by