News

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.
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.