Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.server -> Trying WHERE CONTAINS command

Trying WHERE CONTAINS command

From: Peter DeSimone <pdesimone_at_sageus.com>
Date: 1998/10/12
Message-ID: <6vtkvf$ge9$1@news-2.news.gte.net>#1/1

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 Mon Oct 12 1998 - 00:00:00 CDT

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US