Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.misc -> Re: INSO filter for interMedia Text index
Set a System Environment variable ORACLE_HOME to your Oracle8i home
and reboot. Note that this is *System* environment variable, not
User.
On Fri, 29 Oct 1999 21:52:41 +0700, "Harlin Setiadarma" <harlins_at_bigfoot.com> wrote:
>Hi,
>can anyone help me....
>I have setup Oracle 8i (intel/nt) with interMedia Text option.
>I have setup the extproc in listener.ora and tnsnames.ora.
>I have grant ctxapp to the corresponding user...
>
>I'm also have create a table docs with the following structure :
>seq number primary key
>title varchar2(100)
>content blob
>
>and have populate it with content loaded from pdf documents.
>
>I have create a context index on column content with parameter to enable
>INSO_FILTER.
>
>When I query my table using CONTAINS function :
>
>select title from docs where contains(content,'oracle') > 0;
>
>it does not return any row which mean it cannot find any match for 'oracle'
>literal.
>But I'm very sure that the 'oracle' word is exist somewhere in some .pdf
>that I have load in my BLOB column (content).
>
>I'm also has set the system PATH environment variable to
>c:\oracle\ora8i\ctx\bin.
>But it still doesn't work...
>
>Is anybody know how to setup INSO filter for use with interMedia Text
>index....
>Thanks before.
>
>Regards,
>Harlin Setiadarma
>
>
Thanks!
Joel
Joel R. Kallman Oracle Service Industries
Columbus, OH http://govt.us.oracle.com jkallman@us.oracle.com http://www.oracle.com