FORALL with EXECUTE IMMEDIATE

Hi ALL,

I wanted to use Bulk collect and forall to reduce sql to pl/sql context switch, but forall is not working with execute immediate in one scenario. Please see below examples:-

DECLARE
TYPE r_cursor IS REF CURSOR;
c_delete_cur r_cursor;
v_sql_stmt CLOB;
TYPE clob_tab IS TABLE OF CLOB;
v_delete_clob clob_tab;
BEGIN
v_sql_stmt :=
ncr_mfs_sfw_db_delta_pkg.getdeletescript_new ('NCR_MFS_SFW_TASKS_D',
'NCR_MFS_SFW_TASKS_E'
);
OPEN c_delete_cur FOR v_sql_stmt;
FETCH c_delete_cur
BULK COLLECT INTO v_delete_clob;