APEX

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

Error ORA-01785, while viewing Application Express views in Utilities tab.

580163Sep 3 2009 — edited Sep 3 2009

Hi,
I am unable to see data in Application Express Views in Utilities tab. I am using APEX 3.1.2.

I am getting the following error,

failed to parse SQL query:
ORA-01785: ORDER BY item must be the number of a SELECT-list expression.

There is no sort by in the SQL query. select WORKSPACE, APPLICATION_ID, APPLICATION_NAME
from APEX_APPLICATION_BC_ENTRIES .

Can anyone throw some light on this?

Thanks
Nimmi

Locked Post

New comments cannot be posted to this locked post.

Locked on Oct 1 2009

Added on Sep 3 2009

#apex-discussions

2 comments

350 views