> I received the errors below when I tried to use the examples in Chapter 17
> on interMedia. What do I need in order to use interMedia? Thank you for
> your help.
> 
> Pasin Chanou
> The Boeing Company
> --------------------------------------------------------------------------
> --------------------------------------------------------------------------
> ---------------------------------------------------------------------
> 
> SQL>  @d:\oracle\expert1on1\sourcecodeforweb\chapter17\page742.sql
> SQL> set echo on
> SQL> 
> SQL> 
> SQL> drop index mytext_idx;
> 
> Index dropped.
> 
> SQL> 
> SQL> 
> SQL> create index mytext_idx
>   2  on mytext( thetext )
>   3  indextype is CTXSYS.CONTEXT
>   4  /
> 
> Index created.
> 
> SQL> 
> SQL> 
> SQL> select id
>   2    from mytext
>   3   where contains( thetext, 'near((Oracle,Corporation),10)') > 0;
> select id
> *
> 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
> 
> 
> SQL> 
> SQL> 
> SQL> select score(1), id
>   2    from mytext
>   3   where contains( thetext, 'oracle or california', 1 ) > 0
>   4   order by score(1) desc
>   5  /
> select score(1), id
> *
> 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
> 
> 
> SQL> 
> SQL> 
> SQL> select id
>   2    from mytext
>   3   where contains( thetext, '$train') > 0;
> select id
> *
> 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
> 
> 
> SQL>