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
