Re: DRG-50901: In APEX 5

On 2016/05/04 07:02, rob_at_oraclewizard.com wrote:

> THE FOLLOWING QUERY EXECUTES FINE IN SQL DEVELOPER but raises ORA-20000: Oracle Text error: DRG-50901: text query parser syntax error on line 1, column 1 when executed in an APEX report. Note: this happens even if :p6_search_term is null.
>
> select CASE_ID, ...
> order by case_id;

You don't say where in APEX this query is trying to run, but generally the semi-colon would be left off, like if the SQL is the Region Source (e.g. for a report).

Just a first place to start...

Rich

--
http://www.freelists.org/webpage/oracle-l