I have two indexes on the same table one for the name field (varchar2) and one for the description field (clob).

oms_paragraphs
------------------
ID
NAMEE
TEXTE
DATE_UPDATED
DATE_CREATED

I want to search this table for text that a user entered into a textbox. But I want to search both indexes (OMSPARA_NAMEEN_IDX, OMSPARA_DESCEN_IDX) for matching text. But I get an error when trying to search both indexes

SELECT oms_paragraphs.id,
oms_paragraphs.namee,
oms_paragraphs.texte
FROM oms_paragraphs
WHERE CONTAINS(oms_paragraphs.texte, 'test', 1) > 0
OR CONTAINS(oms_paragraphs.namee, 'test', 1) > 0;

gives ORA-29907: found duplicate labels in primary invocations.