New Analytic Functions for 8i and Stored Procedures 1

[Guest_imported]

Hi,
We recently upgraded to 8i and I have a written a query that uses one of the new analytic functions to show cumulative Dollars... a simple example would be:
Select ename,sal,
SUM(sal) OVER (ORDER BY ename RANGE UNBOUNDED PRECEDING) I_csum
FROM emp;

This works great as a query, but when I try to use this query as a select in a stored procedure, I get error that says the open parenthesis after ther word OVER was unexpected...

Anyone have any idea why???

 

[karluk]

It's unfortunate, but Oracle says that most of the analytic functions are not yet supported in pl/sql. They suggest, as a work around, to create a view that includes the desired function and then have your stored procedure select from the view.

This is definitely not the first time that new sql functionality was unsupported in pl/sql.

 

[SteveQL]

Thanks Carluk, I suspected something like that, but I couldn't find anything in the online documentation...