This discussion is archived
0 Replies Latest reply: Jul 29, 2013 10:13 PM by yannisr RSS

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

yannisr Newbie
Currently Being Moderated

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!

Legend

  • Correct Answers - 10 points
  • Helpful Answers - 5 points