deepinthecode.com
Executing Stored Procedures in Loops Using PL/SQL Tables - Deep in the Code
I needed to be able to run a stored procedure once for each item in a list. In Microsoft SQL Server, I would probably do this with a table variable and a cursor, and the code would look something like this: However, PL/SQL does not have table variables. While an option like a global temporary …