Error in Rownum Select

[emre . hancioglu]

Hello,
Can anyone tell me the reason, why I get an error because of the "Order By"  in Oracle 8.1.5.
It works fine in 8.1.7 and 9.2.

declare
 v_t number(8);
begin
  SELECT tagesdatum into v_t
    FROM (SELECT rownum n, tagesdatum
            FROM (SELECT tagesdatum
                    FROM kalender
                            WHERE  tagesdatum <= to_number(to_char(sysdate,'yyyymmdd'))
                        AND  tag_type = 'A'        
                            ORDER BY tagesdatum DESC
                           )
              )
  WHERE n=6;
end;  



Regards

M.Emre HANCIOGLU
Masterfoods Services GmbH
ISI Application Support
Tel : +49 2162 500-2576
Fax: +49 2162 41497
E-Mail: [EMAIL PROTECTED]