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

In article <2645eb71.fc8f9ad5_at_usw-ex0103-086.remarq.com>, r406 <r406NOr4SPAM_at_hotmail.com.invalid> writes:

>- 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;<<<<<<<<<<this is a role!!!! SEE BELOW...
>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
>

PLS-00201 identifier 'string' must be declared

Cause: An attempt was made to reference either an undeclared variable, exception, procedure, or other item, or an item to which no privilege was granted or AN ITEM TO WHICH PRIVILEGE WAS GRANTED ONLY THROUGH A ROLE.<<<this is your problem

Action:

Check your spelling and declaration of the referenced name.

Verify that the declaration for the referenced item is placed correctly in the block structure.

If the referenced item is indeed declared but you do not have privileges to refer to that item, for security reasons, you will be notified only that the item is not declared.

If the referenced item is indeed declared and you believe that you have privileges to refer to that item, check the privileges; if the privileges were granted only via a role, then this is expected and documented behavior.

Stored objects (packages, procedures, functions, triggers, views) run in the security domain of the object owner with no roles enabled except PUBLIC. Again, you will be notified only that the item was not declared.

Paul in VT Received on Mon Apr 24 2000 - 00:00:00 CDT