dgs!
Member³
It seems that the EXECUTE IMMEDIATE is not getting carried to the next line.
The formatter is doing this:
FORALL i IN tbl.first .. tbl.last EXECUTE IMMEDIATE v_sql USING tbl(i).readmit_key, tbl(i).pat_id, tbl(i)... ETC.
I would like it to do this:
FORALL i IN tbl.first .. tbl.last
EXECUTE IMMEDIATE v_sql USING tbl(i).readmit_key,tbl(i).pat_id, tbl(i)... ETC.
The formatter is doing this:
FORALL i IN tbl.first .. tbl.last EXECUTE IMMEDIATE v_sql USING tbl(i).readmit_key, tbl(i).pat_id, tbl(i)... ETC.
I would like it to do this:
FORALL i IN tbl.first .. tbl.last
EXECUTE IMMEDIATE v_sql USING tbl(i).readmit_key,tbl(i).pat_id, tbl(i)... ETC.