Oracle 8i and interMedia image

From: Yann Doussot <doussot_at_gifrance.com>
Date: 12 Oct 1999 15:40:44 GMT
Message-ID: <slrn806ljv.dht.doussot@orion.gi.fr>

        Hello,

        I'm playing with 8i (standard) and the Image option, and have a simple question. Here is my table:

SQL> desc emp;

 Name                                      Null?    Type
 ----------------------------------------- -------- ----------------------------
 ENAME                                              VARCHAR2(50)
 SALARY                                             NUMBER
 JOB                                                VARCHAR2(50)
 DEPARTMENT                                         NUMBER(38)
 PHOTO                                              ORDSYS.ORDIMAGE
 LARGE_PHOTO                                        ORDSYS.ORDIMAGE

	I inserted an image with this code:

DECLARE
     Image ORDSYS.ORDImage;
     ctx RAW(4000) := NULL;
  BEGIN
     INSERT INTO emp (ename, photo) VALUES ('YD',
     ORDSYS.ORDImage(ORDSYS.ORDSource(empty_blob(), NULL,
                          NULL, NULL, SYSDATE, 1),
                       NULL, NULL, NULL, NULL, NULL, NULL, NULL));
										     SELECT photo INTO Image FROM emp
     WHERE ename = 'YD' FOR UPDATE;
										     Image.importFrom(ctx,
		      'file',
                      'ORDIMGDIR',
                      'logo.jpg');
										    UPDATE emp SET photo = Image WHERE ename='YD'; 

END;
/

        ... so far, so good

        But now I want to save back the image on disk. For what I've seen in the docs, I wrote this procedure:

DECLARE

     Image ORDSYS.ORDImage;
     ctx RAW(4000) := NULL;
BEGIN
      SELECT photo INTO Image FROM emp
         WHERE ename = 'YD' FOR UPDATE;
		                               
      Image.export(ctx,


                   'FILE',


                   'ORDIMGDIR',


                   'logo-small.jpg');


  EXCEPTION
     WHEN ORDSYS.ORDSourceExceptions.SOURCE_PLUGIN_EXCEPTION THEN
      DBMS_OUTPUT.put_line('SOURCE PLUGIN EXCEPTION caught');
     WHEN ORDSYS.ORDSourceExceptions.METHOD_NOT_SUPPORTED THEN
      DBMS_OUTPUT.put_line('SOURCE METHOD_NOT_SUPPORTED caught');
     WHEN ORDSYS.ORDSourceExceptions.INCOMPLETE_SOURCE_INFORMATION THEN
      DBMS_OUTPUT.put_line('SOURCE INCOMPLETE_SOURCE_INFORMATION caught');
     WHEN OTHERS THEN
      DBMS_OUTPUT.put_line('OTHER EXCEPTION caught');

END;
/

        But I receive ... 'SOURCE PLUGIN EXCEPTION caught'. Can anyone help me ? Thanks a lot.

---
Yann Doussot <doussot_at_gifrance.com>
Grey Interactive - France - http://www.gifrance.com/ Cell: +33 6 12 71 70 03 Work: + 33 1 46 84 85 00 Received on Tue Oct 12 1999 - 10:40:44 CDT