tag:blogger.com,1999:blog-13265058.post1491118287579217189..comments2011-10-27T19:40:46.072+11:00Comments on Sydney Oracle Lab: An underhand compilationGary Myershttps://profiles.google.com/116132019768637593422noreply@blogger.comBlogger4125tag:blogger.com,1999:blog-13265058.post-25766099180037240072011-10-26T06:21:10.289+11:002011-10-26T06:21:10.289+11:00And for the end ... imagine if this "implicit...And for the end ... imagine if this "implicit compile" would lead to commit in your session, any production will go crazy because invalid objects!<br />:-)Damir Vadas (aka Funky)http://www.blogger.com/profile/15963017378937428976noreply@blogger.comtag:blogger.com,1999:blog-13265058.post-73800163291248490952011-10-18T08:03:11.616+11:002011-10-18T08:03:11.616+11:00Have you ever try to execute second example withou...Have you ever try to execute second example without implicit recompile:<br />"XE> ALTER PACKAGE PLCH_PKG COMPILE BODY;"<br /><br />Would it be the same?<br />:-)Damir Vadas (aka Funky)http://www.blogger.com/profile/15963017378937428976noreply@blogger.comtag:blogger.com,1999:blog-13265058.post-24750207422361007652011-10-18T08:01:24.889+11:002011-10-18T08:01:24.889+11:00Nice point Vincent, agree with you.
Rg,
DamirNice point Vincent, agree with you.<br />Rg,<br />DamirDamir Vadas (aka Funky)http://www.blogger.com/profile/15963017378937428976noreply@blogger.comtag:blogger.com,1999:blog-13265058.post-24553938544665761662011-10-11T19:48:51.365+11:002011-10-11T19:48:51.365+11:00Hi Gary,
I've always pictured this implicit c...Hi Gary,<br /><br />I've always pictured this implicit compilation as an independent autonomous transaction (so not really cheating :)<br /><br />-- <br />Vincentvnzhttp://www.blogger.com/profile/12833537301091628441noreply@blogger.com