I have deployed an APEX application that is using Oracle TEXT on a host platform. The host is using Oracle 11g XE.
On my local machine I have Oracle 11g XE as well and the application works fine.
I requested the host admin to give my Account the following privileges (per page: http://docs.oracle.com/cd/B28359_01/text.111/b28303/quicktour.htm)
GRANT EXECUTE ON CTXSYS.CTX_CLS TO A13417;
GRANT EXECUTE ON CTXSYS.CTX_DDL TO A13417;
GRANT EXECUTE ON CTXSYS.CTX_DOC TO A13417;
GRANT EXECUTE ON CTXSYS.CTX_OUTPUT TO A13417;
GRANT EXECUTE ON CTXSYS.CTX_QUERY TO A13417;
GRANT EXECUTE ON CTXSYS.CTX_REPORT TO A13417;
GRANT EXECUTE ON CTXSYS.CTX_THES TO A13417;
GRANT EXECUTE ON CTXSYS.CTX_ULEXER TO A13417;
All are set, I can upload a document without any problem, recreated everything but when I run from SQLPLUS a command like:
select DOCUMENT_DATE, PROTOCOL_NO,DOC_ROUTE, DELIVERY_DATE
where contains( contents, :P1_SEARCH, 1) > 0
it returns no data.
What am I missing here?
Thank you in advance for your help!