-
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!!!
-
I would change
END processEntityDeletions;
in
END ; -- processEntityDeletions
-
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.
