Home » Developer & Programmer » Reports & Discoverer » ORA-01785 ERROR (disc 10.1.2)
ORA-01785 ERROR [message #346721] Tue, 09 September 2008 08:54
Messages: 10
Registered: August 2008
Location: USA
Junior Member
Hi all
I created a report and it was running fine for the past 2 months but recently when i tried to run the report either in the discoverer plus or discoverer viewer i'm getting the following error message:

database error-ORA-01785: ORDER BY item must be the number of a SELECT-list expression.

I'm using a VIEW and i didn't make any changes to the view and the sql generated doesnt have the "ORDER BY" clause. Any help is gretaly appreciated.

Next Topic: Problem in Report Builder
Goto Forum:

Current Time: Mon Aug 21 09:07:54 CDT 2017

Total time taken to generate the page: 0.02256 seconds