please send me also On Sat, Apr 9, 2011 at 9:45 PM, Michael Moore <[email protected]>wrote:
> The procedure will be marked as invalid. The next time you try to run the > procedure it will do 2 things 1) raise an error and 2) attempt to compile > the procedure. If the compile is good, then the next time you try to run the > procedure, it will run. > > There might be other factors which cause different behavior for a given > environment. So, you should try it. > > Mike > > > On Sat, Apr 9, 2011 at 6:58 AM, Rohit aphale <[email protected]>wrote: > >> Hi, >> I have a doubt and i need the answer to it ,my question is suppose we >> have created a package specification and a package body and a >> standalone procedure ,we make a change in the package body and the pkg >> body is recompiled,what happens if the standalone procedure references >> the package, will the standalone procedure invalidated or validated? >> Plz reply as soon as possible. >> Thanks in advance. >> >> -- >> You received this message because you are subscribed to the Google >> Groups "Oracle PL/SQL" group. >> To post to this group, send email to [email protected] >> To unsubscribe from this group, send email to >> [email protected] >> For more options, visit this group at >> http://groups.google.com/group/Oracle-PLSQL?hl=en > > > -- > You received this message because you are subscribed to the Google > Groups "Oracle PL/SQL" group. > To post to this group, send email to [email protected] > To unsubscribe from this group, send email to > [email protected] > For more options, visit this group at > http://groups.google.com/group/Oracle-PLSQL?hl=en > -- Thanks, N.Senthil. -- You received this message because you are subscribed to the Google Groups "Oracle PL/SQL" group. To post to this group, send email to [email protected] To unsubscribe from this group, send email to [email protected] For more options, visit this group at http://groups.google.com/group/Oracle-PLSQL?hl=en
