Code problem

[netbar]

This loop is at the end of a procedure I have, it should truncate the aforementioned table.

However I get the error:

LINE/COL ERROR
-------- -----------------------------------------------------------------
204/5 PLS-00103: Encountered the symbol "PROCESSENTITYDELETIONS" when
expecting one of the following:
loop

BEGIN
--LOOP Delete_Entity_Loop
LOOP
--
-- Now to truncate the tibex_deleteAction
--
log_message(' Truncating the tibex_deleteAction table.');
execute immediate 'truncate table tibex_deleteAction';

log_message(' Completed processEntityDeletions: ' || v_processed
|| ' entries processed');
END LOOP;
END;
END processEntityDeletions;


please advise!!!

[denevge]

I would change

END processEntityDeletions;

in

END ; -- processEntityDeletions

[defraine]

There's and extra 'END' in the code. The last matches to the 'BEGIN' and the second to last matches to 'LOOP', leaving the 'END LOOP' hanging out there.