Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.server -> conText option
Hi,
I have some questions regarding conText. I have a table url_store with the following columns.
create table url_store(
url_id number(10) constraint pk_url_id primary key,
url_string varchar2(256),
c_date date);
I also created a policy for it as follows:
begin
ctx_ddl.set_attribute('MAXDOCSIZE', 200000);
ctx_ddl.create_preference('LIB_PREF2', 'External URL Storage', 'URL');
end;
/
begin
ctx_ddl.create_policy(policy_name => 'LIB_POL2',
colspec => 'URL_STORE.URL_STRING', description => 'Text Search using URL', textKey => 'URL_STORE.URL_ID', wordlist_pref => 'CTXSYS.SOUNDEX', filter_pref => 'HTML_DOC2', engine_pref => 'MED_INDEX2', dstore_pref => 'LIB_PREF2' );
I also ctx_ddl.index().
Question is :
1) How can my application display the result because my table does not
contain the actual document?
2) Also...can the url_string be an owa call instead of just being a static file?
Thanks & regards! Received on Wed Jan 21 1998 - 00:00:00 CST