Re: SQL, ConText, interMedia confusion

"Cody Ebberson" <cebberson_at_centilliondigital.com> wrote in message news:6e0eb547.0107160754.5cb4bdff_at_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

Question: You do have the Enterprise Edition and you do have Intermedia installed, and you did read the installation documents? You say you are missing a file. Isn't it possible Intermedia wasn't installed at all on your site?

Regards,

Sybrand Bakker, Senior Oracle DBA Received on Mon Jul 16 2001 - 11:51:53 CDT