1.正常sql:
2.动态sql:
returning id into :1 --把更新表中的id放到一个名称叫1的空间,名称任意取
execute immediate nb_sql returning bulk collect into nb_rwid;
for i in nb_rwid.first .. nb_rwid.last loop
up_mid_99201001(nb_rwid(i),1,null,rc1=>nb_rc1,rc2=>nb_rc2);
end loop;
commit;