Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
![]() |
![]() |
Home -> Community -> Usenet -> c.d.o.server -> Trying WHERE CONTAINS command
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:
![]() |
![]() |