Thanks, thats actually a cut and paste from sql developer, the APEX code does
not include the ';'.
===================================
Robert P. LockardOracle ACEPresident Oraclewizard.com, Inc. The question is not
“who is going to let me,” it's “who is going to stop me." Ayn Rand
(cell) 571.276.4790
(office) 410.766.6960
(fax) 410.766.0332
twitter @navonpilot
youtube https://www.youtube.com/user/n4281k
blog: http://www.oraclewizard.com
-----Original Message-----
From: Rich J [mailto:rjoralist3@xxxxxxxxxxxxxxxxxxxxx]
Sent: Wednesday, May 4, 2016 09:31 AM
To: oracle-l@xxxxxxxxxxxxx
Subject: Re: DRG-50901: In APEX 5
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
