Home » SQL & PL/SQL » SQL & PL/SQL » Procedure missing to execute
Procedure missing to execute [message #407750] Thu, 11 June 2009 07:12 Go to next message
rtnataraj
Messages: 102
Registered: December 2008
Senior Member

Hi all,

I have a list of procedures which does some comparision of two tables and logs the difference in a report table.

I have a master procedure too, for calling all the other procedures.

While executing my master procedure, some time one or two procedures are missing to execute.

I can't figure out what's the problem and how these procedures are missed from the execution.

help me.


regards,
Nataraj
Re: Procedure missing to execute [message #407751 is a reply to message #407750] Thu, 11 June 2009 07:13 Go to previous messageGo to next message
pablolee
Messages: 2834
Registered: May 2007
Location: Scotland
Senior Member
Because you haven't included them in the execution list.
Re: Procedure missing to execute [message #407766 is a reply to message #407750] Thu, 11 June 2009 08:30 Go to previous messageGo to next message
rtnataraj
Messages: 102
Registered: December 2008
Senior Member


No, I had Included every one of them,
This is a peculiar case,

Do any one have any clue??


regards,
Nataraj.
Re: Procedure missing to execute [message #407768 is a reply to message #407766] Thu, 11 June 2009 08:42 Go to previous messageGo to next message
Michel Cadot
Messages: 64120
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
The procedure calls are in comment.

Regards
Michel
Re: Procedure missing to execute [message #407771 is a reply to message #407766] Thu, 11 June 2009 08:53 Go to previous messageGo to next message
JRowbottom
Messages: 5933
Registered: June 2006
Location: Sunny North Yorkshire, ho...
Senior Member
If you think the replies you are getting aren't very helpful, it's because you have given us nothing to work with.

All you have provided is your understanding of the situation, and as the situation makes no sense to you, what you have described makes no sense.

Do you get any error messages?
Can you show us the structure of your code?
Does your code do anything with dynamic SQL or is it all hard coded?
Re: Procedure missing to execute [message #407772 is a reply to message #407766] Thu, 11 June 2009 08:53 Go to previous messageGo to next message
pablolee
Messages: 2834
Registered: May 2007
Location: Scotland
Senior Member
rtnataraj wrote on Thu, 11 June 2009 14:30

No, I had Included every one of them,



No you didn't.
Either that or you have a
WHEN OTHERS THEN
 NULL;
END;

In your code.

[Updated on: Thu, 11 June 2009 08:54]

Report message to a moderator

Re: Procedure missing to execute [message #407773 is a reply to message #407768] Thu, 11 June 2009 08:54 Go to previous messageGo to next message
pablolee
Messages: 2834
Registered: May 2007
Location: Scotland
Senior Member
Michel Cadot wrote on Thu, 11 June 2009 14:42
The procedure calls are in comment.



Laughing
Re: Procedure missing to execute [message #407810 is a reply to message #407773] Thu, 11 June 2009 13:19 Go to previous messageGo to next message
ThomasG
Messages: 3189
Registered: April 2005
Location: Heilbronn, Germany
Senior Member
Another possibility would be that the procedures really ARE called, but they just don't do anything because of a completely different bug in the code.
Re: Procedure missing to execute [message #407813 is a reply to message #407750] Thu, 11 June 2009 13:22 Go to previous message
BlackSwan
Messages: 25041
Registered: January 2009
Location: SoCal
Senior Member
>help me.
Help you solve your mystery?
You provided no actual facts or clues.

You need to help us by following the Posting Guidelines as stated below.
http://www.orafaq.com/forum/t/88153/0/
Go to the URL above click the link "Posting Guidelines"
Go to the section labeled "Practice" & do as directed
Previous Topic: Order of Data Dispaly / printing has changed!
Next Topic: Calling java function from remote unix server
Goto Forum:
  


Current Time: Tue Dec 06 14:18:43 CST 2016

Total time taken to generate the page: 0.12402 seconds