BULK COLLECT INTO clause with EXECUTE IMMEDIATE statement store values - SQL Operations
Q. You can use the BULK COLLECT INTO clause with the EXECUTE IMMEDIATE statement to store values from each column of a query's result set in a separate collection.- Published on 19 Oct 15a. Yes
b. No
ANSWER: Yes
The BULK sql passes an entire collection to and fro. The BULK COLLECT INTO clause is used to execute the statements immediately.