Yes you are right. On Sat, Apr 9, 2011 at 9:45 PM, Michael Moore <michaeljmo...@gmail.com>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 <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 > -- 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
