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