0 Replies Latest reply: Jul 30, 2013 12:13 AM by yannisr RSS

    Oracle text results on a hosted APEX platform (11g XE) not returning results

    yannisr

      Hi,

      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

        from lib_documents

      where contains( contents, :P1_SEARCH, 1) > 0

       

      it returns no data.

       

      What am I missing here?

       

      Thank you in advance for your help!