在一个SQL文件中创建多个过程? [英] Create more than one procedure in a SQL file?

问题描述

我想在一个SQL文件中创建多个过程，即:

I want to create more than one procedure in a SQL file, ie:

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;

这样做会引发错误:

错误(10,1):PLS-00103:遇到符号创建"

Error(10,1): PLS-00103: Encountered the symbol "CREATE"

我该怎么做?由于某些限制，创建软件包不是一个选择.

How can I do this? Creating a package ins't an option due to some limitations.

推荐答案

添加/

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;
/

这篇关于在一个SQL文件中创建多个过程?的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！