haspath, inpath für xml data in blob column

Hi all,
i have tried to insert my 10 xml data in the blob column. It's successful (After the inserting
i have checked it additionally). Now i want to use INPATH and HASPATH to search attribut and
element's value in the xml data. The Index with preference path_section_group is created. But
i get no result for the searching. My programmcode are shown following:

CREATE TABLE xmlblob_table(id int CONSTRAINT xmlblob_index PRIMARY KEY not null, xml_dok
BLOB) cstmt = conn.prepareCall("{call Ctx_Ddl.create_section_group(?, ?)}");

cstmt.setString(1, "xmlpathgroup");
cstmt.setString(2, "PATH_SECTION_GROUP");
cstmt.execute();

CREATE INDEX xml_index ON xmlblob_table(xml_dok) INDEXTYPE IS CTXSYS.CONTEXT
PARAMETERS('SECTION GROUP xmlpathgroup')     

SELECT id FROM xmlblob_table
WHERE CONTAINS(xml_dok, '"Billy Tilla" INPATH(//author)')>0"; //WHERE CONTAINS(xml_dok, 'HASPATH(document1/title1)')>0";

I am sure, "Billy Tilla" is stored inside more author tags and document1 is the direct
parentage for the title1 tag in a xml data.

I think, it is possible the index is not correctly erzeugt. But i can not find any probleme.
Please help?

thank you very much and greeting from germany!

rabbit Received on Tue Dec 09 2003 - 15:42:59 CST