Re: Problem matching against Oracle CLOB
Re: Problem matching against Oracle CLOB
- Subject: Re: Problem matching against Oracle CLOB
- From: Kaj Hejer <email@hidden>
- Date: Wed, 9 Apr 2003 19:59:24 +0200
At 10:29 -0700 09-04-2003, John Boynton wrote:
Hi.
I've submitted a bug report (# 3222966) on this problem to Apple, but
would like to know about any possible workarounds from folks here.
The problem is this: If you try to do a query match against an attribute
whose external data type is CLOB, the qualifier looks like
Hi!
You need to use Oracle Itermedia (or Oracle Intermedia Text or Oracle
Text or whatever they call it. They change the name of this feature
for each new Oracle relase ;-)
See
<url:http://developer.apple.com/techpubs/webobjects/WebObjects_5/Topics/ProgrammingTopics.3a.html>
(a few years ago Oracle Itermedia was called Oracle Context)
and
<url:http://otn.oracle.com/products/intermedia/content.html>
for more info.
We use the following sql in one of our applications to create the
indexes for Oracle Intermedia:
exec ctx_ddl.create_section_group('mysection','basic_section_group');
exec ctx_ddl.create_preference('mysection','basic_wordlist');
exec ctx_ddl.set_attribute('mysection', 'SUBSTRING_INDEX', 'TRUE');
drop index answer_index;
create index answer_index on answer(a_text2)
indextype is ctxsys.context
parameters ('storage ctxsys.tblsp_text_index section group
mysection stoplist ctxsys.empty_stoplist');
drop index question_index;
create index question_index on question(q_text)
indextype is ctxsys.context
parameters ('storage ctxsys.tblsp_text_index section group
mysection stoplist ctxsys.empty_stoplist');
-Kaj :)
_______________________________________________
webobjects-dev mailing list | email@hidden
Help/Unsubscribe/Archives: http://www.lists.apple.com/mailman/listinfo/webobjects-dev
Do not post admin requests to the list. They will be ignored.