Home » Developer & Programmer » Reports & Discoverer » ORA-01785 error :ORDER BY item must be the number of a SELECT-list expressi (disc 10.1.2)
ORA-01785 error :ORDER BY item must be the number of a SELECT-list expressi [message #422755] Fri, 18 September 2009 13:52 Go to next message
aarti81
Messages: 235
Registered: December 2007
Location: USA
Senior Member
When i'm sorting on a calculated field i'm getting the following error:

ORDER BY item must be the number of a SELECT-list expression

Please any help?

Thanks
Re: ORA-01785 error :ORDER BY item must be the number of a SELECT-list expressi [message #422768 is a reply to message #422755] Fri, 18 September 2009 23:37 Go to previous messageGo to next message
shaz
Messages: 182
Registered: June 2009
Senior Member
This generally occurs when you are using a column alias which is used in the ORDER BY clause of a SELECT statement that uses a UNION, INTERSECT, or MINUS set operator.

Re: ORA-01785 error :ORDER BY item must be the number of a SELECT-list expressi [message #483714 is a reply to message #422755] Wed, 24 November 2010 04:28 Go to previous messageGo to next message
dshakthi
Messages: 5
Registered: January 2008
Location: Bangalore
Junior Member
could you please provide the query which you have used
Re: ORA-01785 error :ORDER BY item must be the number of a SELECT-list expressi [message #483715 is a reply to message #483714] Wed, 24 November 2010 04:30 Go to previous message
cookiemonster
Messages: 12320
Registered: September 2008
Location: Rainy Manchester
Senior Member
I'd like to hope that the OP has fixed the issue in the year that has past since he posted it.
Previous Topic: How do I modify an xml template
Next Topic: SRW.SET_FORMAT_MASK-- creating issues
Goto Forum:
  


Current Time: Sun Sep 25 09:29:19 CDT 2016

Total time taken to generate the page: 0.10053 seconds