Multi Word Fuzzy
If my search text contains one word the query brings the results. If it contains more it gives error ORA-20000 ORACLE TEXT ERROR DRG-50901 TEXT QUERY PARSER SYNTAX ERROR.
Here's the query
SELECT DISTINCT D.DOC_ID,
DOCUBANK.GET_FOLDER( IC.FOLDER_ID ) FOLDER,
IC.INDEX_CARD
FROM DOCS D, INDEX_CARDS IC,
DOC_INDEX_FIELDS DIF
WHERE D.DOC_ID = DIF.DOC_ID
AND D.INDEX_CARD_ID = IC.INDEX_CARD_ID
AND ( (UPPER(DIF.VALUE) LIKE '%'||UPPER(:P10_SEARCH_TEXT)||'%'
OR UPPER(D.REMARKS) LIKE '%'||UPPER(:P10_SEARCH_TEXT)||'%')
OR CONTAINS (theBfile, 'fuzzy (' || :P10_SEARCH_TEXT ||')') > 0 )