2 Replies Latest reply: Jan 22, 2013 1:05 PM by 986480 RSS

    Invalid attributes in ORDSys.IMGSimilar

    299046
      Hi,

      I am trying to compare images stored as ORDSys.ORDImage, but keep getting an error. The query below works ok, but just as long as I use integers;

      SELECT a.title, b.title
      FROM image a, image b
      WHERE ORDSys.IMGSimilar( a.imagesig, b.imagesig, 'shape="0" color="1"', 11 ) = 1
      AND a.imageid <> b.imageid;


      I want to be able to use floating-point numbers, as the intermedia documentation shows. The following query fails;

      SELECT a.title, b.title
      FROM image a, image b
      WHERE ORDSys.IMGSimilar( a.imagesig, b.imagesig, 'color="0.2" texture="0.1" shape="0.5" location="0.2"', 11 ) = 1
      AND a.imageid <> b.imageid;


      ...and the error message is as follows (translated from local language):

      ORA-29400: datacartridgeerror
      IMG-00803: invalid attribute value
      ORA-06512: at "ORDSYS.SCOREFUNC", line 0
      ORA-06512: at "ORDSYS.SIMILARFUNC", line 22


      Might this relate to a technical problem with the database, or am I just plain stupid?

      Thanks in advance,
      Alexander Mossin