I cannot find the mistake in the below code, I receive "statement ignored error" at the last line of the first select clause part of the code:
SELECT *
BULK COLLECT INTO l_employees
FROM employees;
But I am not sure if thats the real problem. Here is my full code
declare
j number := 0;
indx number;
begin
SELECT *
BULK COLLECT INTO l_employees
FROM employees;
indx := l_empoyees.count;
for r in (select * from sde.sdeuser_abone2)
loop
update sde.sdeuser_abone2
set bina_id = l_employees(indx).ID
where objectid = r.objectid;
indx := indx - 1;
if indx = 0 then
indx := l_empoyees.count;
end if;
end loop;
commit;
end;
Thanks for helping,
Yassar