Hi,

There is a limit for the DO_SQL Procedure to DDL Statements

The DO_SQL procedure is useful for executing DDL statements.
However, do not use this procedure to execute DML statements.
In general, DML statements are executed more efficiently within program units than with the DO_SQL procedure.

Vidya..

[email protected]