Re: Oracle Text

From: Giannis A <gexakis_at_hotmail.com>
Date: Tue, 15 Apr 2003 20:46:04 +0300
Message-ID: <b7hggs$cv9$1@usenet.otenet.gr>

I 've run the following code and it seems that WITHIN is valid

begin
ctx_ddl.create_section_group('basicgroup', 'BASIC_SECTION_GROUP'); ctx_ddl.add_field_section('basicgroup', 'Author', 'A', FALSE); end;
/

create table publications
(
public_id number,
text varchar2(200),
constraint publications_pk
primary key(public_id)
);

create table profiles
(
profile_id number,
rule varchar2(500),
constraint pro_pk
primary key(profile_id)
);

create INDEX profile_index on profiles(rule) PARAMETERS('section basicgroup') indextype is CTXSYS.CTXRULE;

insert into profiles(profile_id,rule) values(4,'Charles WITHIN author'); ....<other profiles>

insert into publications(public_id,text) values(2,'<a> Charles Dickens </a> <t> Some title </t>');
......<other pulbications>

Upon matching the publications with the profiles 4 is a matched one . I guess you are right but bugs like these are unexpected from Oracle. Unfortunately I don't have support....

"Hans Forbrich" <forbrich_at_telusplanet.net> wrote in message news:3E9C21C5.CBEA55FE_at_telusplanet.net...
> I would consider this a documentation 'bug'. Therefore (and assuming you
have
> support) I'd suggest opening a TAR about this so the documentation can get
> fixed.

> IIRC, WITHIN is valid. Why not experiment a bit?
> Received on Tue Apr 15 2003 - 12:46:04 CDT