Home » SQL & PL/SQL » SQL & PL/SQL » How to execute 5 procedures, one after another?
How to execute 5 procedures, one after another? [message #673203] Mon, 12 November 2018 00:38 Go to next message
nagarajut80
Messages: 3
Registered: October 2018
Junior Member
I have 5 Procs to execute one after one if one success then other. if error then stops the process and return an error.


[SPLIT from http://www.orafaq.com/forum/stt/4819/ by LF]

[Updated on: Mon, 12 November 2018 16:08] by Moderator

Report message to a moderator

Re: Trouble with sqlplus command in batch file [message #673204 is a reply to message #673203] Mon, 12 November 2018 01:05 Go to previous messageGo to next message
Michel Cadot
Messages: 67363
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator

And the problem is?

By the way, did you solve your problem in your previous topic?
If so, then post the solution or at least feedback.

Re: Trouble with sqlplus command in batch file [message #673207 is a reply to message #673203] Mon, 12 November 2018 01:48 Go to previous messageGo to next message
John Watson
Messages: 8344
Registered: January 2010
Location: Global Village
Senior Member
Souds like a usage case a Scheduler Job Chain,
https://docs.oracle.com/en/database/oracle/oracle-database/18/admin/scheduling-jobs-with-oracle-scheduler.html#GUID-BF3AB6EB-BC19-430 3-9E02-6466804BA119
Re: Trouble with sqlplus command in batch file [message #673209 is a reply to message #673207] Mon, 12 November 2018 02:11 Go to previous messageGo to next message
Michel Cadot
Messages: 67363
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator

Or just:
begin 
  proc1;
  proc2;
  ...
end;
/
Re: Trouble with sqlplus command in batch file [message #673210 is a reply to message #673209] Mon, 12 November 2018 02:14 Go to previous messageGo to next message
nagarajut80
Messages: 3
Registered: October 2018
Junior Member
Thanks

But, I want to pass parameters ( <Period>,<Year>), These parameters will call from the Batch file(Windows).
Re: Trouble with sqlplus command in batch file [message #673212 is a reply to message #673210] Mon, 12 November 2018 02:53 Go to previous messageGo to next message
gazzag
Messages: 1082
Registered: November 2010
Location: Bristol, UK
Senior Member
Has anyone noticed that this topic is over fourteen years old?
Re: Trouble with sqlplus command in batch file [message #673215 is a reply to message #673210] Mon, 12 November 2018 05:26 Go to previous message
Michel Cadot
Messages: 67363
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
nagarajut80 wrote on Mon, 12 November 2018 09:14
Thanks

But, I want to pass parameters ( <Period>,<Year>), These parameters will call from the Batch file(Windows).
So create your own topic in Windows forum for this specific question.

And feedback in your previous topic posting what I asked if you want help.

Previous Topic: Last and Sum in group by
Next Topic: Relationship between two weak entities
Goto Forum:
  


Current Time: Fri Sep 18 03:48:37 CDT 2020