OraFAQ Forum: SQL & PL/SQL » retrieving image from database

Home » SQL & PL/SQL » SQL & PL/SQL » retrieving image from database

Show: Today's Messages :: Polls :: Message Navigator
E-mail to friend

retrieving image from database [message #228052]

Sat, 31 March 2007 01:20

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

Report message to a moderator

Re: retrieving image from database [message #228113 is a reply to message #228052]

Sat, 31 March 2007 15:49

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

Report message to a moderator

Re: retrieving image from database [message #228121 is a reply to message #228113]

Sat, 31 March 2007 23:10

Mohammad Taj
Messages: 2412
Registered: September 2006
Location: Dubai, UAE

Senior Member

Hi,

Good Work !!!

Regards
Taj

Report message to a moderator

Re: retrieving image from database [message #228137 is a reply to message #228121]

Sun, 01 April 2007 06:37

shanthkumaar
Messages: 156
Registered: February 2007
Location: india,chennai

Senior Member

hi Taj,

thanks Cool

regards,
shanth

Report message to a moderator

Re: retrieving image from database [message #229029 is a reply to message #228113]

Thu, 05 April 2007 01:48

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

Report message to a moderator

Re: retrieving image from database [message #229033 is a reply to message #229029]

Thu, 05 April 2007 02:10

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.

Report message to a moderator

Re: retrieving image from database [message #229162 is a reply to message #229029]

Thu, 05 April 2007 10:46

ThomasG
Messages: 3212
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.

Report message to a moderator

Re: retrieving image from database [message #229548 is a reply to message #229033]

Mon, 09 April 2007 02:08

harshalonline22
Messages: 74
Registered: March 2007
Location: Pune

Member

My dear Frnd,
Front end means Oracle forms 6i in my case.

Report message to a moderator

Previous Topic:	open source tool for debugging
Next Topic:	UTL_TCP package

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Fri Dec 06 16:49:40 CST 2024