send me 2 On 4/11/11, senthil natarajan <senthilnatarajan...@gmail.com> wrote: > please send me also > > 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 >> > > > > -- > 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 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
-- *********Harsh Damania************* -- 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
