Home » Developer & Programmer » JDeveloper, Java & XML » haspath, inpath für xml data in blob column
haspath, inpath für xml data in blob column [message #91957] Tue, 09 December 2003 14:35
Messages: 6
Registered: October 2003
Junior Member
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

cstmt = conn.prepareCall("{call Ctx_Ddl.create_section_group(?, ?)}");
cstmt.setString(1, "xmlpathgroup");
cstmt.setString(2, "PATH_SECTION_GROUP");

CREATE INDEX xml_index ON xmlblob_table(xml_dok) INDEXTYPE IS CTXSYS.CONTEXT

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!

Previous Topic: unsupported feature in jdbc CallableStatement
Next Topic: ORACLE and the Web
Goto Forum:

Current Time: Tue Aug 03 21:50:35 CDT 2021