Home » SQL & PL/SQL » SQL & PL/SQL » Running multiple procedures from one script file
Running multiple procedures from one script file [message #1977] Fri, 14 June 2002 04:48 Go to next message
Al P.
Messages: 5
Registered: February 2002
Junior Member
I am trying to create a script file which will run and process multiple procedures.
Please assist.

Thanks,

Al P.
Re: Running multiple procedures from one script file [message #1981 is a reply to message #1977] Fri, 14 June 2002 08:42 Go to previous messageGo to next message
Mahesh Rajendran
Messages: 10707
Registered: March 2002
Location: oracleDocoVille
Senior Member
Account Moderator
What kind of a script file you are looking into?
Just sql/plsql or shell or windowsscripts?
Re: Running multiple procedures from one script file [message #1985 is a reply to message #1977] Fri, 14 June 2002 09:28 Go to previous messageGo to next message
Al P.
Messages: 5
Registered: February 2002
Junior Member
Just a pl/sql script. I don't know how to code more than one script at a time and put into a file which will process one at a time.

Thanks,

Al P.
Re: Running multiple procedures from one script file [message #1995 is a reply to message #1985] Fri, 14 June 2002 15:34 Go to previous message
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> 
Previous Topic: Progress of a SQL call
Next Topic: comparision with data type LONG
Goto Forum:
  


Current Time: Mon May 20 12:46:43 CDT 2024