Stange Problem of Cursors (Combination of Minus and Order by Clause)

Hi,

[Quoted]       I used the following query as cursor in creating a package body:

    select clli_org, trk_org, node_org
    from trunklis
    where trk_date='23-aug-98'
    minus
   select clli_org,trk_org,node_org
   from trunklis
   where trk_date='16-aug-98'
   order by node_org;

it is giving the following error:
order by item must be in Select-list expression.

If i run the same query at SQL prompt, it is working fine.

Can any one tell me What is the possible reason for this? Received on Thu Aug 27 1998 - 00:00:00 CEST