Oracle: DBMS_SQL.EXECUTE

dbms_sql.execute executes the statement that was parsed with dbms_sql.parse.

Return value

For DML statements, dbms_sql.execute returns the number of affected (processed) records.

For select statements, the returned value is undefined