Split does not work properly

The split does not work properly for the below Oracle Stored procedure

CREATE OR REPLACE EDITIONABLE PROCEDURE "OWB_ADMIN"."AZBJ_RI_LIMIT_PROC"
AS
week_date_first DATE := TRUNC (azbj_pme_api.opus_date - 7);
week_date_last DATE := TRUNC (azbj_pme_api.opus_date - 1);
BEGIN
logtrace ('LOG',
10001,
'PROC AZBJ_RI_LIMIT_PROC STARTED',
'AZBJ_RI_LIMIT_PROC');
BEGIN
EXECUTE IMMEDIATE ('DROP TABLE STG_RI_LIMIT_DATA PURGE');
EXCEPTION
WHEN OTHERS
THEN
NULL;
END;
END;