3 Replies Latest reply: Nov 9, 2010 11:40 AM by mannamal RSS

    Error in ORDSYS.ORDImage when processing JPEG, ---   GIF works well

    astramare
      Error when processing JPEG, GIF works well

      Oracle 9i

      Image Size ca 700 x 600 pixel

      I have a procedure like this :


      create or replace procedure "ABC"."GET_PROCESSED_PHOTO"(
      p_photoID PHOTO.PHOTO_ID%TYPE,
      p_img OUT BLOB)
      IS
      v_ordImg ORDSYS.ORDImage;
      v_tmpImg ORDSYS.ORDImage;
      BEGIN
      SELECT PHOTO_CONT INTO v_ordImg FROM PHOTO WHERE PHOTO_ID = p_photoID;
      IF v_ordImg IS NOT NULL THEN
      v_tmpImg := ORDSYS.ORDImage.init();
      DBMS_LOB.CreateTemporary(v_tmpImg.source.localdata, TRUE);
      v_ordImg.copy(v_tmpImg);

      v_tmpImg.process('maxScale=80 80'); // this point get the error

      p_img := v_tmpImg.getContent();
      dbms_lob.FreeTemporary(v_tmpImg.source.localdata);
      END IF;
      END;

      When work with GIF it run's ok,

      when work with JEPEG it's get a Error
      on v_tmpImg.process('maxScale=80 80'); :

      ....
      System.Data.OracleClient.OracleException: ORA-29400: Data Cartridge-Error
      IMG-00703: cannot read Image ( Image-Daten können nicht gelesen werden )
      ...

      does JPEG need other image-types or other parametersor memory or restrictions then GIF ?