Logo Questions Linux Laravel Mysql Ubuntu Git Menu
 

Oracle 11g : Sql Developer : How to execute more than one anonymous block

I am trying to execute a list of anonymous block in sql developer. But when ever execute a anonymous block example

Begin
 execute do something
end;

it works but if i execute more than one anonymous block such as

Begin
 execute do something
end;
Begin
 execute do something
end;

it throws

PLS-00103: Encountered the symbol "BEGIN" 
06550. 00000 -  "line %s, column %s:\n%s"
*Cause:    Usually a PL/SQL compilation error.
like image 825
Dineshkumar Avatar asked Dec 25 '22 11:12

Dineshkumar


1 Answers

Use forward slash in between

Begin
 execute do something
end;
/

Begin
 execute do something
end;
/
like image 160
San Avatar answered Dec 28 '22 08:12

San