0 Replies Latest reply: Feb 1, 2009 11:06 AM by 437917 RSS

    SI_StillImage, data cartridge error

    437917
      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