Re: help on export images.

Hi,

Have a look at a migration tool Chyfo (www.ispirer.com/products). It can export BLOBs from Oracle to separate files.

For example,

chyfo /d=ora_base /u=usr /p=pwd /s="select image_data from tab1"

Best regards, Dmitry.

"Kai Huang" <khuang_at_andrew.cmu.edu> wrote in message news:Pine.GSO.4.33L-022.0109182116440.20279-100000_at_unix1.andrew.cmu.edu...
> Hi Folks,
>
> We have an image database using Oracle8i interMedia datatype ORDImage. We
> have stored some images in the database as ORDImage, however, when we want
> to export the images to the operating system as external files, we met the
> following compiling error:
>
> ORA-06510: PL/SQL: unhandled user-defined exception
> ORA-06512: at "ORDSYS.ORDSOURCE", line 354
> ORA-29540: class oracle/ord/media/source/OrdSourceSvr does not exist
> ORA-06512: at line 9
>
> The pl/sql codes we used to export are from the Oracle8i interMedia
> document. We also tried to store the images as BLOB and use the downloaded
> interMedia relational interface to call ORDSYS.ORDImage.export() function
> and it gave us the same error. Does the error message mean that the java
> class OrdSourceSvr doesn't exist? We are very confused by trying different
> methods for almost a week. PS, could anyone tell us some place to look for
> experiences in building image database and applications? Thank you guys
> so much.
>
> Very best regards,
> Kai
>
Received on Wed Sep 19 2001 - 06:30:24 CDT