export blob images

[bookouri]

I have a table of stored photos like
image_id pk
image_date date
image_data blob

I need to come up with some way to select a date range of photos and create .jpg files from the image_data so that i end up with a number of .jpg files named based on the image_id||'.jpg'..

I dont know the best place to start on this one.

Can anybody point me in the right direction?

 

[LKBrwnDBA]

Try using a combination of the DBMS_LOB and UTL_FILE packages.


----------------------------------------------------------------------------
The person who says it can't be done should not interrupt the person doing it. -- Chinese proverb

 

[bookouri]

thanks, that did it..