Re: Image Retrieval Methodology Needed

On 5 Mar 2004 12:09:52 -0800, sdrichardson_at_direcway.com (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!

You would better convert to BLOBs and you can use the Oracle supplied DBMS_LOB package.

--
Sybrand Bakker, Senior Oracle DBA