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;

Report message to a moderator

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

Report message to a moderator

Previous Topic: Is it possible to.....
Next Topic: NEED HELP WITH CASE STATEMENT
Goto Forum:
  

[ Syndicate this forum (XML) ] [ RSS ]

Current Time: Wed Jul 23 12:02:30 CDT 2025
.:: Forum Home :: Blogger Home :: Wiki Home :: Contact :: Privacy ::.