PLS-00201 while querying w/ interMedia (ConText) index

From: r406 <r406NOr4SPAM_at_hotmail.com.invalid>
Date: 2000/04/20
Message-ID: <2645eb71.fc8f9ad5@usw-ex0103-086.remarq.com>#1/1

• Oracle 8.1.5, Solaris
• text_enable is set to TRUE
• ctxsrv is running

I run these statements:

connect system/password
grant ctxapp to scott;
connect scott/tiger;
create table test ( num number(3), text long ); alter table test add constraint test_pk primary key ( num);

insert into test values ( '1','AA');
insert into test values ( '2','BB');
insert into test values ( '3','ABC');
insert into test values ( '4','CCC');

begin
ctx_ddl.create_preference('CTX_SCOTT','BASIC_STORAGE');

ctx_ddl.set_attribute('CTX_SCOTT','I_TABLE_CLAUSE','tablespace
indx storage (initial 10k next 10k pctincrease 0)');
ctx_ddl.set_attribute('CTX_SCOTT','K_TABLE_CLAUSE','tablespace
indx storage (initial 10k next 10k pctincrease 0)');
ctx_ddl.set_attribute('CTX_SCOTT','R_TABLE_CLAUSE','tablespace
indx storage (initial 10k next 10k pctincrease 0)');
ctx_ddl.set_attribute('CTX_SCOTT','N_TABLE_CLAUSE','tablespace
indx storage (initial 10k next 10k pctincrease 0)');
ctx_ddl.set_attribute('CTX_SCOTT','I_INDEX_CLAUSE','tablespace
indx storage (initial 10k next 10k pctincrease 0)');

end;
/

All of these statements run w/ no errors, but when want to run a query using the domain index I just created, I get:

select num from test where contains(text,'A')>0;

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

Any thoughts? Thanks.

• Sent from RemarQ http://www.remarq.com The Internet's Discussion Network * The fastest and easiest way to search and participate in Usenet - Free!

Received on Thu Apr 20 2000 - 00:00:00 CDT