Error when inserting Images ( in BFILE ) with setSource on Oracle 9.0.1.3.0

From: Christian M. <cm_at_sdv.fr>
Date: Wed, 10 Apr 2002 12:04:56 +0200
Message-ID: <3cb40eaa$0$197$4d4eb98e@read.news.fr.uu.net>

Hi,

I have this error when i insert an image in a bfile column with the function SetSource in PLSQL.

ERREUR à la ligne 1 :

ORA-29540: classe oracle/ord/media/img/PropsAdapter inexistante
ORA-06512: à "ORDSYS.ORDIMG_PKG", ligne 590
ORA-06512: à "ORDSYS.ORDIMAGE", ligne 65
ORA-06512: à ligne 6

My PLSQL is :

SQL> DECLARE
  2 Image1 ORDSYS.ORDImage;
  3 BEGIN
  4 SELECT PHOTO INTO Image1 FROM MAT_PHOTO WHERE NO_MATERIEL = 11439 FOR UPDATE
  5 Image1.setSource('file','IMAGES_MATERIEL','aurore.jpg');   6 Image1.setProperties;
  7 UPDATE MAT_PHOTO SET PHOTO = Image1 WHERE NO_MATERIEL = 11439 ;   8 COMMIT;
  9 END;
10 /

Any Idee ???

Thanks in advance.

Christian. Received on Wed Apr 10 2002 - 05:04:56 CDT