This discussion is archived
4 Replies Latest reply: Sep 3, 2013 5:50 AM by miersuzzemes Branched from an earlier discussion. RSS

Re: ORA-29400 when converting image to thumbnail

miersuzzemes Newbie
Currently Being Moderated

Hello.

I have the same problem.

Uploaded the pic in Droplr: http://d.pr/i/fRDt

 

My code looks loke:

DECLARE

   l_file_id            fnd_lobs.file_id%TYPE := 5395382;

   l_image_blob         BLOB;

   l_compress_command   VARCHAR2(4000);

BEGIN

   SELECT file_data INTO l_image_blob FROM fnd_lobs WHERE file_id = l_file_id FOR UPDATE;

   l_compress_command := 'maxScale=300,300';

   ORDSYS.ORDImage.process(l_image_blob, l_compress_command); -- Source, Command

END;

/

 

And I get:

ORA-29400: data cartridge error

IMG-00002: unrecoverable error

ORA-06512: at "ORDSYS.ORDIMERRORCODES", line 75

ORA-06512: at "ORDSYS.ORDIMERRORCODES", line 65

ORA-06512: at "ORDSYS.ORDIMG_PKG", line 155

ORA-06512: at "ORDSYS.ORDIMAGE", line 1366

ORA-06512: at line 8

 

As you can see I am using the FND standard table but that is irrelevant I think. The column fnd_lobs.file_data stores BLOB.

Database Version : 11.2.0.3.0