Home » Server Options » Text & interMedia » Problem in Context option
Problem in Context option [message #366437] Sat, 05 August 2000 02:03 Go to next message
Messages: 18
Registered: April 1999
Junior Member
when i execute the query
select column from table where contains
(column,'text') > 0;
eg. select label_value from item_labels where
contains (label_value,'grammy') > 0

get the following errors.

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 am started a server and created an index.
how these errors are solved?
please help.

thanks in advance.
Re: Problem in Context option [message #366440 is a reply to message #366437] Mon, 07 August 2000 07:43 Go to previous message
sharan alva
Messages: 57
Registered: November 1999
This looks like you are issuing the query in version 8.1.x and you have text_enabled = true set in your init.ora. set this parameter to false and you should be all set. When you install contest using dbassist this puts the parameter in your init.ora and hence your problem.
Previous Topic: Help requested - context cartridge
Next Topic: Context Error Message
Goto Forum:

Current Time: Thu May 19 19:24:23 CDT 2022