Re: Trying WHERE CONTAINS command

What you are trying to use is query syntax particular to context cartridge. So, in the unlikely event that you have a context policy on All_tab_COLUMNS, check the grants against the CTXSYS.DR_REWRITE package, I think that PUBLIC should have execution rights to the package as part of the default set up of context.

If however I have completely confused you by discussing Oracle Context, try the following

select *
from All_tab_COLUMNS
where table_name like '$TSP'

the CONTAINS keyword is specific to context queries

Hope this helps

Rod J. Stewart

Peter DeSimone wrote in message <6vtkvf$ge9$1_at_news-2.news.gte.net>...
>I try this command in Oracle SQL Worksheet:
>
>select * from All_tab_COLUMNS where CONTAINS(TABLE_NAME, '$TSP')>0;
>
>
>I get this error:
>
>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
>
>
>
>
Received on Tue Oct 13 1998 - 00:00:00 CDT