Home » SQL & PL/SQL » SQL & PL/SQL » Copy the image file to a folder (oracle 10gr2)
Copy the image file to a folder [message #393963] Wed, 25 March 2009 03:51 Go to next message
srinivas.k2005
Messages: 342
Registered: August 2006
Senior Member
Hi,

We have requirement like,
We need to copy the Blob(Image file) from database server to a web server system folder.

The image file is available in a table in the blob column, so whenever they update/insert/delete i need to copy the image to a shared folder of Web server system.

Can we do this? If yes please guide me on this requirement

Thanks,
Srinivas
Re: Copy the image file to a folder [message #393985 is a reply to message #393963] Wed, 25 March 2009 05:01 Go to previous messageGo to next message
Michel Cadot
Messages: 64151
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
Select it and write it in your web server.

Regards
Michel
Re: Copy the image file to a folder [message #394038 is a reply to message #393963] Wed, 25 March 2009 08:26 Go to previous messageGo to next message
srinivas.k2005
Messages: 342
Registered: August 2006
Senior Member
Sorry i am not clear ,select is fine and how to put it in a folder in web server system.
May be i need to place the copy the images from the blob column and place the images in a folder like C:\images in web server system.
Re: Copy the image file to a folder [message #394039 is a reply to message #394038] Wed, 25 March 2009 08:28 Go to previous messageGo to next message
Michel Cadot
Messages: 64151
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
It is the problem of your application server to write in on the web server once you select it, it is not the problem of Oracle.

Regards
Michel
Re: Copy the image file to a folder [message #394054 is a reply to message #393963] Wed, 25 March 2009 09:53 Go to previous message
BlackSwan
Messages: 25050
Registered: January 2009
Location: SoCal
Senior Member

You need to help us by following the Posting Guidelines as stated below.
http://www.orafaq.com/forum/t/88153/0/

use UTL_FILE
Previous Topic: Date between issue
Next Topic: Function in predicate slowing query
Goto Forum:
  


Current Time: Fri Dec 09 17:45:53 CST 2016

Total time taken to generate the page: 0.27668 seconds