Re: DRG-50901: In APEX 5
- From: Rich J <rjoralist3@xxxxxxxxxxxxxxxxxxxxx>
- To: oracle-l@xxxxxxxxxxxxx
- Date: Wed, 04 May 2016 08:31:54 -0500
On 2016/05/04 07:02, rob@xxxxxxxxxxxxxxxx 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
Other related posts: