Split does not work properly

[corncat-liu]

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;

[andialbrecht]

Here's a simplified version of the same bug taken from the Oracle reference:

>>> sql = """CREATE PROCEDURE remove_emp (employee_id NUMBER) AS
...    tot_emps NUMBER;
...    BEGIN
...       DELETE FROM employees
...       WHERE employees.employee_id = remove_emp.employee_id;
...    tot_emps := tot_emps - 1;
...    END;"""
>>>
>>> len(sqlparse.split(sql))
4
>>> sqlparse.split(sql)
['CREATE PROCEDURE remove_emp (employee_id NUMBER) AS\n   tot_emps NUMBER;',
 'BEGIN\n      DELETE FROM employees\n      WHERE employees.employee_id = remove_emp.employee_id;',
 'tot_emps := tot_emps - 1;',
 'END;']
>>>