Home » SQL & PL/SQL » SQL & PL/SQL » Run two procedures one after the other
Run two procedures one after the other [message #18519] Mon, 04 February 2002 02:27 Go to next message
Rm69
Messages: 39
Registered: January 2002
Member
have two procs. l would like to run the next proc y after x is finished. How can l do that? Which is just

CREATE OR REPLACE procedure x
AS
BEGIN........etc
end;
Re: Run two procedures one after the other [message #18520 is a reply to message #18519] Mon, 04 February 2002 03:25 Go to previous message
Suresh Vemulapalli
Messages: 624
Registered: August 2000
Senior Member
write script like this(say script.sql) and call from sqlplus

exec x;
exec y;

or

begin
x;
y;
end;

SQL> @script.sql
Previous Topic: Is it possible to.....
Next Topic: NEED HELP WITH CASE STATEMENT
Goto Forum:
  


Current Time: Thu Mar 28 15:12:51 CDT 2024