Home » SQL & PL/SQL » SQL & PL/SQL » Calling procedure scenario
Calling procedure scenario [message #337841] Fri, 01 August 2008 05:51 Go to next message
gauravpuri2002
Messages: 24
Registered: October 2007
Location: Bangalore
Junior Member
Hi
I have 2 procedures A and B.Procedure A has to call procedure B and procedure B has to call procedure A.How should I implement this scenario
Re: Calling procedure scenario [message #337851 is a reply to message #337841] Fri, 01 August 2008 06:20 Go to previous messageGo to next message
Michel Cadot
Messages: 64152
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
In the most simple way, just create both.

My advice is to create them in a single package.

Regards
Michel
Re: Calling procedure scenario [message #337856 is a reply to message #337851] Fri, 01 August 2008 06:26 Go to previous messageGo to next message
gauravpuri2002
Messages: 24
Registered: October 2007
Location: Bangalore
Junior Member
Thanks for reply.......
If i create in single package also both are calling each other so i will result in indefinate loop.

Regards
Gaurav
Re: Calling procedure scenario [message #337857 is a reply to message #337856] Fri, 01 August 2008 06:27 Go to previous message
Michel Cadot
Messages: 64152
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
If you just do this, of course but it will quickly end with an error.

Regards
Michel
Previous Topic: Run procedure parallaly
Next Topic: Need a better query
Goto Forum:
  


Current Time: Sat Dec 10 12:51:58 CST 2016

Total time taken to generate the page: 0.11734 seconds