| ORA-01785 ERROR [message #346721] |
Tue, 09 September 2008 08:54 |
kimber
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.
Thanks
|
|
|
|
] 
Blog
Search
Help
Members
Register
Login
Home
