This discussion is archived
3 Replies Latest reply: Nov 9, 2010 9:40 AM by mannamal RSS

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

astramare Newbie
Currently Being Moderated
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 ?

Legend

  • Correct Answers - 10 points
  • Helpful Answers - 5 points