update first 3 rows from each deptno

Hi Akkerend,
The below is Beforereport of developer 2000, but when I compile I get error.



function BeforeReport return boolean is
begin
EXECUTE IMMEDIATE 'update emp e
set e.sal = e.sal+100
where e.empno in (select s.empno
from (select e2.empno,
row_number() over
(partition by e2.deptno order by e2.ename)
as rownumber
from emp e2) s
where s.rownumber <=3)';
return (TRUE);
end;


Thanks in advance.

The PL/SQL version in Developer 2000 is an old version of PL/SQL, probably too old for execute immediate. Maybe you can try the procedure DBMS_UTILITY.EXEC_DDL_STATEMENT to execute the update statement. Or use a view.

Hi Akkerend,

Thanks for your help and provide solution. I will work on this over the weekend and will update you.

Appreciate.