This discussion is archived
2 Replies Latest reply: Jan 22, 2013 11:05 AM by 986480 RSS

Invalid attributes in ORDSys.IMGSimilar

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