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 <rohitapha...@gmail.com> 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 Oracle-PLSQL@googlegroups.com > To unsubscribe from this group, send email to > oracle-plsql-unsubscr...@googlegroups.com > 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 Oracle-PLSQL@googlegroups.com To unsubscribe from this group, send email to oracle-plsql-unsubscr...@googlegroups.com For more options, visit this group at http://groups.google.com/group/Oracle-PLSQL?hl=en
