Re: order by clause in cursors?

Are you sure the order by witch rows are fetched is not OK? I have never seen anything unusual with ORDER BY in a cursor. What is the type of column "a"? What are your NLS parameters?

Regards,

Jurij Modic					Republic of Slovenia
tel: +386 61 178 55 14			Ministry of Finance
fax: +386 61  21 45 84			Zupanciceva 3
e-mail: jurij.modic_at_mf.sigov.mail.si	Ljubljana 1000

On 28 May 1997 17:33:10 GMT, kirill_at_cs.ualberta.ca (Kirill Richine) wrote:

>Hi!
>
>I am trying to declare a cursor in the following way:
>
>cursor c is
>select a
>from b
>order by a;
>...
>
>However, when I iterate through it, the rows are actually not ordered
>by column a.
>
>How can I do it, and what's wrong with what I am doing?
>
>Thank you.
>k&
>
>
Received on Thu May 29 1997 - 00:00:00 CEST