Hello,
While parsing PL/SQL code that includes the LISTAGG(... ON OVERFLOW TRUNCATE) construction using the ZPA Toolkit, we encountered incorrect tokenization. This leads to faulty rule execution in affected cases.
Example:
select listagg(my_text_field, ';' on overflow truncate) from my_table;
Due to the incorrect parsing, certain rules behave unexpectedly:

Additionally, when executing any test in the zpa-main project that involves the ON OVERFLOW TRUNCATE clause, an exception is thrown:
We kindly ask you to investigate and resolve this parsing issue.
Thank you.
Hello,
While parsing PL/SQL code that includes the LISTAGG(... ON OVERFLOW TRUNCATE) construction using the ZPA Toolkit, we encountered incorrect tokenization. This leads to faulty rule execution in affected cases.
Example:
select listagg(my_text_field, ';' on overflow truncate) from my_table;
Due to the incorrect parsing, certain rules behave unexpectedly:
We kindly ask you to investigate and resolve this parsing issue.
Thank you.