Home » SQL & PL/SQL » SQL & PL/SQL » retrieving image from database
retrieving image from database [message #228052] Sat, 31 March 2007 01:20 Go to next message
harshalonline22
Messages: 74
Registered: March 2007
Location: Pune
Member
Suppose we have stored an image in database table column of
bfile datatype.
Now i want to retrieve that image from the database and show it onto front end like D2k tools,etc..
How to achieve that???

Regards,
Harshal
Re: retrieving image from database [message #228113 is a reply to message #228052] Sat, 31 March 2007 15:49 Go to previous messageGo to next message
shanthkumaar
Messages: 156
Registered: February 2007
Location: india,chennai
Senior Member

hi,
a search gave me this...
hope this helps you...

oracle faq1

oracle faq2

oracle faq3

oracle faq4

asktom

regards,
shant
Re: retrieving image from database [message #228121 is a reply to message #228113] Sat, 31 March 2007 23:10 Go to previous messageGo to next message
Mohammad Taj
Messages: 2412
Registered: September 2006
Location: Dubai, UAE
Senior Member

Hi,

Good Work !!!



Regards
Taj


Re: retrieving image from database [message #228137 is a reply to message #228121] Sun, 01 April 2007 06:37 Go to previous messageGo to next message
shanthkumaar
Messages: 156
Registered: February 2007
Location: india,chennai
Senior Member

hi Taj,

thanks Cool

regards,
shanth
Re: retrieving image from database [message #229029 is a reply to message #228113] Thu, 05 April 2007 01:48 Go to previous messageGo to next message
harshalonline22
Messages: 74
Registered: March 2007
Location: Pune
Member
thanx for that.

But in case if u have stored a media file in databse of any extension say for eg. *.wmv,*.avi,*.dat.

and u wan to play that on the front end.How to do that?


Regards,
Harshal
Re: retrieving image from database [message #229033 is a reply to message #229029] Thu, 05 April 2007 02:10 Go to previous messageGo to next message
shanthkumaar
Messages: 156
Registered: February 2007
Location: india,chennai
Senior Member

hi

front end. what is the front end suppose to be?
and may be you could do that i have never come across that, so i do not know. Embarassed

i believe some expert here will help you out...


regards,
shanth.
Re: retrieving image from database [message #229162 is a reply to message #229029] Thu, 05 April 2007 10:46 Go to previous messageGo to next message
ThomasG
Messages: 3189
Registered: April 2005
Location: Heilbronn, Germany
Senior Member
But in case if u have stored a media file in databse of any extension say for eg. *.wmv,*.avi,*.dat.


Then you have one general problem. When the file is in the database it doesn't have a filename, and so it doesn't have an extension.

So you will have to have some other column in the table that tells you what type of media file it actually is, or what filename it is supposed to have when it's transferred somewhere else.
Re: retrieving image from database [message #229548 is a reply to message #229033] Mon, 09 April 2007 02:08 Go to previous message
harshalonline22
Messages: 74
Registered: March 2007
Location: Pune
Member
My dear Frnd,
Front end means Oracle forms 6i in my case.
Previous Topic: open source tool for debugging
Next Topic: UTL_TCP package
Goto Forum:
  


Current Time: Fri Dec 09 09:51:32 CST 2016

Total time taken to generate the page: 0.13209 seconds