How to use RANK in a procedure ?

[rk68]

I'm getting the following error when using "RANK" in a procedure.
PLS-00103-Encountered the symbol "(" when expecting the following: , from

The SQL used in the procedure is >>
SELECT t.bookerid,sum(t.billamount)/100000,
rank() over ( partition by to_char
(t.checkoutdate,'YYYYMM')
order by to_char(t.checkoutdate,'YYYYMM'),
sum (t.billamount) desc last nulls )
from taj_rmg_bookermast t

What could be the error ? I have executed this SQL through PL/SQL developer & its working fine.

TIA
RK

 

[Dagon]

I think ranking functions weren't supported in PL/SQL in Oracle 8 ("case" was the same). You could try putting it in a view and just referencing the view in the PL/SQL.