Processing occurs one at a time and calls a SQL Server stored procedure. The SPROC is recursive. For each ID that is submitted, it can have any number of child ID's.

The native PL/SQL insert statement in the first example actually generates a recursive SQL statement--' insert into mytestvalues (:1)'--and binds the values on each iteration.