|
|
|
Re: Running multiple procedures from one script file [message #1995 is a reply to message #1985] |
Fri, 14 June 2002 15:34 |
|
Mahesh Rajendran
Messages: 10707 Registered: March 2002 Location: oracleDocoVille
|
Senior Member Account Moderator |
|
|
this may help you.
create the stored procedures.
create the sql script, to run these proceudres(here all.sql).
run the sql script.
SQL> get one
1 create or replace procedure one
2 as
3 begin
4 dbms_output.put_line('Procedure One is executed');
5* end;
SQL> /
Procedure created.
SQL> get two
1 create or replace procedure two
2 as
3 begin
4 dbms_output.put_line('Procedure two is executed');
5* end;
SQL> .
SQL> /
Procedure created.
SQL> get three
1 create or replace procedure three
2 as
3 begin
4 dbms_output.put_line('Procedure three is executed');
5* end;
SQL> /
Procedure created.
SQL> get all
1 set feedback off;
2 exec one;
3 exec two;
4 exec three;
5* set feedback on;
SQL> @all
Procedure One is executed
Procedure two is executed
Procedure three is executed
SQL>
|
|
|