Create multiple procedures in SQL file?

I want to create several procedures in an SQL file, i.e.

create or replace procedure pro1 as begin null; end pro1; create or replace procedure pro2 as begin null; end pro2; create or replace procedure pro3 as begin null; end pro3; 

The execution of this error is:

Error (10.1): PLS-00103: "CREATE" symbol detected

How can i do this? Creating a package is not an option due to some limitations.

+6
source share
1 answer

Add /

 create or replace procedure pro1 as begin null; end pro1; / create or replace procedure pro2 as begin null; end pro2; / create or replace procedure pro3 as begin null; end pro3; / 
+9
source

Source: https://habr.com/ru/post/900632/


All Articles