This discussion is archived
0 Replies Latest reply: Feb 1, 2009 9:06 AM by 437917 RSS

SI_StillImage, data cartridge error

437917 Newbie
Currently Being Moderated
Hi
I have an existing images table in my Oracle database (11g)
CREATE TABLE ZDJECIA_TV (
OPIS CHARACTER VARYING(100) PRIMARY KEY,
NAZWA CHARACTER VARYING(50),
ZDJECIE SI_STILLIMAGE
);
CREATE TABLE succeeded.
Next: INSERT INTO.............

OK


and next,
-------------------------------------------------
declare
pieces utl_http.html_pieces;
pict blob:=empty_blob;
buf raw(32767);
tempzdjec si_stillimage;
cursor z is select nazwa,zdjecie from zdjecia_tv for update of zdjecie;
begin
for x in z loop
pieces := utl_http.request_pieces('http://......'||x.nazwa,32767);
dbms_lob.createtemporary(pict, TRUE);
dbms_lob.open(pict, dbms_lob.lob_readwrite);
FOR i in 1 .. pieces.count loop
buf:=UTL_RAW.cast_to_raw(pieces(i));
dbms_lob.writeappend(pict,utl_raw.length(buf),buf);
END LOOP;
dbms_lob.close(pict);
     tempzdjec:=si_stillimage(pict);
     tempzdjec.si_initfeatures();
     update zdjecia_tv set zdjecie=tempzdjec where current of z;
dbms_lob.freetemporary(pict);
end loop;
end;
/
------------------------------------------------------
Error report:
ORA-29400: data cartridge error
IMG-00705: unsupported or corrupted input format
ORA-06512: at "ORDSYS.ORDIMERRORCODES", line 75
ORA-06512: at "ORDSYS.ORDIMERRORCODES", line 65
ORA-06512: at "ORDSYS.ORDIMG_PKG", line 47
ORA-06512: at "ORDSYS.ORDIMAGE", line 786
ORA-06512: at "ORDSYS.SI_STILLIMAGE", line 58
ORA-06512: at line 17
29400. 00000 - "data cartridge error\n%s"
*Cause:    An error has occurred in a data cartridge external procedure.
This message will be followed by a second message giving
more details about the data cartridge error.
*Action:   See the data cartridge documentation
for an explanation of the second error message.


Could anybody please help me?

Thanks much,
Marta

Legend

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