Recommand · June 8, 2021 0

Toad SQLPlus – @Script run serial or parallel

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.