当对Report进行排序时,有时候报出错误ORA-00933,原因是Report的SQL Query (PL/SQL function body returning SQL query)中含有Order By语句。网上说这个APEX bug在4.0.2中已经fix啦,但是,我们在4.1.0中仍然会遇到。原因不清楚。一种折中解决方法是删掉SQL Query中的Order By语句,只是用column sort。
ORA-00933: SQL command not properly ended
SQL> desc apex_release;
Name Null? Type
----------------------------------------- -------- ----------------------------
VERSION_NO VARCHAR2(4000)
API_COMPATIBILITY VARCHAR2(4000)
PATCH_APPLIED VARCHAR2(4000)
SQL> select version_no from apex_release;
VERSION_NO
--------------------------------------------------------------------------------
4.1.0.00.32
参考:
【1】https://forums.oracle.com/forums/thread.jspa?threadID=2124510
【2】https://forums.oracle.com/forums/thread.jspa?threadID=2387116