SQL, ConText, interMedia confusion

From: Cody Ebberson <cebberson_at_centilliondigital.com>
Date: 16 Jul 2001 08:54:00 -0700
Message-ID: <6e0eb547.0107160754.5cb4bdff@posting.google.com>

Ok, first of all, I'm just an intern, so please go easy on me.

I'm trying to add fuzzy searches to our web application (i.e. stem, fuzzy, and soundex), but I am having some problems getting it to work.  I am using Oracle 8i (version 8.1.7).

Earlier, I could use a "where contains(...)" statement and it would work succesffully. However, I set "text_enable=true" in my "init.ora" file and ran the "dr0inst.sql" script (which produced a lot of errors...), and now when I try to use a "where contains" statement I get the following error:

ERROR at line 1:

ORA-00604: error occurred at recursive SQL level 1
ORA-06550: line 1, column 7:
PLS-00201: identifier 'CTXSYS.DR_REWRITE' must be declared
ORA-06550: line 1, column 7:

PL/SQL: Statement ignored

I read in a different thread that I was also supposed to run "drcrsyst.sql" but I do not have this file.

I realize that I am probably forgetting an obvious piece of information, but if anyone out there could possibly give me an ounce of help, it would be greatly appreciated. All I want to be able to do is use the fuzzy features in a search. If I am on the completely wrong track, please let me know and point me to the right track. Thanks in advance!!

-Cody Received on Mon Jul 16 2001 - 10:54:00 CDT