Displaying images thats stored in Oracle database in CGI script

[Robert Nilsson]

Hi all

I've asked this before, but I've lost track of any answers. I've got a
Oracle database that includes pictures. I want to display some text
information along with some smaller pictures in an Internet Explorer window
through a CGI script. I've got everything working when we talk about text,
but images??? I have no idea how to treat the image data that is stored in a
BLOB column in Oracle.

Anyone out there who got some tips and/or examples how to do it?


Best regards

Robert Nilsson

 

[Gunnar Hjalmarsson]

I've asked this before, but I've lost track of any answers.

So, why don't you try to find them? Or is it more convenient (to you)
to make people post the same answers again?

http://groups.google.se/[email protected]

 

[gnari]

Hi all

I've asked this before, but I've lost track of any answers.

then google is your friend

... I've got a
Oracle database that includes pictures. I want to display some text
information along with some smaller pictures in an Internet Explorer window
through a CGI script. I've got everything working when we talk about text,
but images??? I have no idea how to treat the image data that is stored in a
BLOB column in Oracle.

Anyone out there who got some tips and/or examples how to do it?

your <img> tag has a src="http://yourscript"

yourscript uses DBI to read the BLOB,
does binmode STDOUT if server is windows,
prints a Content-Type: image/whatever HTTP header before the content,
and then barfs out the BLOB to STDOUT.

gnari

 

[Robert Nilsson]

So, why don't you try to find them? Or is it more convenient (to you)
to make people post the same answers again?

http://groups.google.se/[email protected]

Ofcourse it is
And thanks!

....or it could be that some people (like me) didn't know there was a way to
find old news messages. It's your pick.


/ Robert

 

[Gunnar Hjalmarsson]

...or it could be that some people (like me) didn't know there was
a way to find old news messages.

Well, now you know there is: http://groups.google.com/

 

[Joe Smith]

yourscript uses DBI to read the BLOB,
does binmode STDOUT if server is windows,

Does binmode(STDOUT) if the server is Red Hat Linux with localization
set to UTF-8.

Best to always use binmode() when dealing with binary data, even on
Unix/Linux/POSIX.
-Joe