Running loop in script in sql plus

Question

I am running a script in sql plus, I have a for loop in my script:

BEGIN
  FOR count IN 1..100 LOOP
    INSERT INTO CompanyShare VALUES (count, 1, 250);
  END LOOP;
END;

BEGIN
  FOR count IN 101..200 LOOP
    INSERT INTO CompanyShare VALUES (count, 2, 50);
  END LOOP;
END;

When I run the script this error came up:

ORA-06550: line 6, column 1: PLS-00103: Encountered the symbol "BEGIN"

Where am I going wrong?

you missed a ; at the END of first block. And I would not use count as variable name, as it is a sql reserved word. — Florin Ghita
– Florin Ghita, Commented Nov 26, 2012 at 12:48

Robert · Accepted Answer · 2012-11-26 13:07:00Z

4

Try to add / after end; as below:

BEGIN
  FOR count IN 1..100 LOOP
    INSERT INTO CompanyShare VALUES (count, 1, 250);
  END LOOP;
END;
/ --<-- Here
BEGIN
  FOR count IN 101..200 LOOP
    INSERT INTO CompanyShare VALUES (count, 2, 50);
  END LOOP;
END;

answered Nov 26, 2012 at 13:07

Robert

25.8k8 gold badges70 silver badges86 bronze badges

Sign up to request clarification or add additional context in comments.

1 Comment

user1844205 Over a year ago

Thanks...Now my script is running

Gaurav Soni · Accepted Answer · 2012-11-26 13:41:12Z

3

Looking to your logic ,you can even simplify the script based on condition .

  BEGIN
  FOR count IN 1..200
   LOOP
    INSERT INTO CompanyShare VALUES (count
                                    ,CASE WHEN count<=100 THEN 1   ELSE 2  END
                                    ,CASE WHEN count<=100 THEN 250 ELSE 50 END
                                    );
   END LOOP;
  END;
  /

answered Nov 26, 2012 at 13:41

Gaurav Soni

6,37610 gold badges55 silver badges72 bronze badges

Comments

Viru · Accepted Answer · 2012-11-26 12:55:42Z

0

Semicolon is not there after end .Try this

BEGIN
  FOR count IN 1..100 LOOP
   INSERT INTO CompanyShare VALUES (count, 1, 250);
  END LOOP;
END ;   --****
BEGIN
 FOR count IN 101..200 LOOP
  INSERT INTO CompanyShare VALUES (count, 2, 50);
 END LOOP;
END;

answered Nov 26, 2012 at 12:55

Viru

5332 gold badges7 silver badges15 bronze badges

Collectives™ on Stack Overflow

Running loop in script in sql plus

3 Answers 3

1 Comment

Comments

Comments

Your Answer

Linked

Hot Network Questions

Collectives™ on Stack Overflow

3 Answers 3

1 Comment

Comments

Comments

Your Answer

Sign up or log in

Post as a guest

Linked

Related