OraFAQ Forum: Server Administration » Two Procedures calling each other

Home » RDBMS Server » Server Administration » Two Procedures calling each other

Show: Today's Messages :: Polls :: Message Navigator
E-mail to friend

Two Procedures calling each other [message #370104]

Thu, 14 December 2000 23:51

mini
Messages: 3
Registered: December 2000

Junior Member

I am trying to create 2 procedures in the following way. Proc1 calls Proc2 and Proc2 calls Proc1. But Oracle 7.3.3. gives all kinds of messages like deadlock detected , Internal Error etc. Is it possible to have this kind of a situation. If yes, how to do it?

Report message to a moderator

Re: Two Procedures calling each other [message #370105 is a reply to message #370104]

Fri, 15 December 2000 03:48

John R
Messages: 156
Registered: March 2000

Senior Member

Try this:

Create a stub procedure called 'Proc1'
Write Proc2, calling proc1
rewrite proc1.

If this doesn't work, could you be a bit more explicit about the errors you are getting?

Report message to a moderator

Re: Two Procedures calling each other [message #370136 is a reply to message #370104]

Wed, 20 December 2000 05:44

Kannan
Messages: 29
Registered: September 2000

Junior Member

U can call the proc1 in proc2 but before that it
has to be declared as forward declaration then
only it will work. Define the proc2 in
declaration setion of the proc1

Report message to a moderator

Previous Topic:	problem with trigger and commit
Next Topic:	How to know procedure name from the same procedure.

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Sat Aug 16 16:28:25 CDT 2025