ORA-20000 is no other messages following it
select m.id,m.create_date,t.textcol from texttable t, maintable m where m.id = t.id(+) and contains(t.textcol,'%knn or rgb%')=0 and m.create_date>='2009-08-22';
The user wanted to see all rows created on or after 22Aug09, and if they had a row in the texttable, then also see the contents of that row PROVIDED the textcol did NOT contain the strings specified. The query returned ORA-20000 with no other explanation. An explain plan showed that the database was not using the text index on textcol but was doing a full scan on texttable, and then filtering. If I changed it to an equijoin, then the text index was used.