I am using Toad and I have following code to run several PL/SQL scripts "in a row" (via Execute SQL via SQLPlus button):
DECLARE start_date_key NUMBER(38); end_date_key NUMBER(38); BEGIN start_date_key := 20210501; end_date_key := 20210531; FOR i IN start_date_key .. end_date_key LOOP @1_script1.sql; @2_script2.sql; @3_script3.sql; END LOOP; END;
But from error messages it makes me confused, because it seems to me, that it runs all scripts at once (in parallel, not serial – as I want). Can you correct me, if I am wrong?
How this SQLPlus executor will execute these kind of PL/SQL script?
Thank you very much.