Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.misc -> Re: Image Retrieval Methodology Needed
Steve wrote:
> I have a huge collection of images stored within Oracle (datatype
> "Long Raw"). Periodically, I need to extract any number of images,
> creating individual .jpg files from them.
>
> I need to be able to perform this, preferably thru a DB procedure
> (yeah, PL/SQL) to which I pass parameters.
>
> I do not need code assistance on the looping issue for performing
> multiple images. What I need is a good code example of how to extract
> the long raw image, convert it for storage into a .jpg, & how to
> create the flat file for that .jpg.
>
> Any assistance which can be provided will be most appreciated.
> Replies may be posted either directly to this group or Emailed to
> myself at sdrichardson_at_removethis.direcway.com
>
> Thx!
If by 'extract with PL/SQL' you mean create files on a hard disk it isn't going to happen. Look for someone to write some code for you in C or Java.
-- Daniel Morgan http://www.outreach.washington.edu/ext/certificates/oad/oad_crs.asp http://www.outreach.washington.edu/ext/certificates/aoa/aoa_crs.asp damorgan_at_x.washington.edu (replace 'x' with a 'u' to reply)Received on Fri Mar 05 2004 - 17:04:37 CST