Context Cartridge

From: Niels Voorhoeve <nvoorhoeve_at_ftpoint.com>
Date: Sat, 11 Sep 1999 18:20:30 -0500
Message-ID: <7rekej$a91$1@brinkley.rutgers.edu>

Hi,

We installed Oracle with the context cartridge, and can create indexes, but the contains(column,'whatever')>0 queries return no rows. The indexes were created in same session prior to running the queries. I set text_enable = false with alter session (it is set true in the instance init file) in order to get the queries not to give errors (but also not return rows). But when text_enable is set true in the session I get the following error:

RA-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

Apparently, permissions is an issue here. I found that the CTXADMIN and CTXUSER roles do not exist, when I try to assign them. What's going on here?

-Niels Received on Sat Sep 11 1999 - 18:20:30 CDT