CREATE OR REPLACE PROCEDURE DB IS
tmpVar NUMBER;
BEGIN
tmpVar := 4001;
for i in 1..tmpVar loop
[color=red][u]your sql[/u][/color]
commit;
end loop;
EXCEPTION
WHEN NO_DATA_FOUND THEN
NULL;
WHEN OTHERS THEN
-- Consider logging the error and then re-raise
RAISE;
END DB;
/
tmpVar NUMBER;
BEGIN
tmpVar := 4001;
for i in 1..tmpVar loop
[color=red][u]your sql[/u][/color]
commit;
end loop;
EXCEPTION
WHEN NO_DATA_FOUND THEN
NULL;
WHEN OTHERS THEN
-- Consider logging the error and then re-raise
RAISE;
END DB;
/