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;
Doing this throws an error:
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.
Option 1: Use the scripting wizard Right-click the db --> tasks --> Generate scripts --> go through the wizard. Option 2: Open the stored procedures folder in SSMS (in the object explorer details window) You can use shift click to select all the stored procedures and you can then right_click and script them to a file.
In other words, you can't have two procedures with the same name and input argument data types but different output argument types. The owner or a superuser can replace the body of a stored procedure with a new one with the same signature.
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;
/
If you love us? You can donate to us via Paypal or buy me a coffee so we can maintain and grow! Thank you!
Donate Us With