does not work as function / procedure..why

[crystaljen]

hi,
when i run this sql statement using ORacle 8...it works but when i use the same statement in a function and procedure i encountered error PLS:00103...

statement as below

(select field_name1 from
(select DISTINCT field_name1
, ROW_NUMBER()
over (partition by fld2, fld3 order by field_name1) as rec from xyz_tbl
WHERE fld2 = 'abc' AND fld3 = '123)
where rec = 6)

can someone pls advise as what went wrong..

thanks for helping

 

[sem]

Analytical functions are not implemented in pl/sql engine on 8i. Thogh, you may execute it dynamically.