tag:blogger.com,1999:blog-4677316190423110840.post1761009546289933004..comments2023-08-25T13:49:41.382+02:00Comments on Software Engineer Thoughts: Caution: FOR loop and CONTINUE in Oracle 11gPaweł Baruthttp://www.blogger.com/profile/16867021334037413869noreply@blogger.comBlogger10125tag:blogger.com,1999:blog-4677316190423110840.post-42519468484084038662016-12-28T15:28:23.920+01:002016-12-28T15:28:23.920+01:00Very nice blog for CONTINUE
Please CONTINUE postin...Very nice blog for CONTINUE<br />Please CONTINUE posting such things!Nitinnoreply@blogger.comtag:blogger.com,1999:blog-4677316190423110840.post-87139663671518077202015-11-11T19:30:27.910+01:002015-11-11T19:30:27.910+01:00Thanks for the blog ! I saw the same issue and was...Thanks for the blog ! I saw the same issue and wasted so much time thinking I had misused CONTINUE somehow . Surprised to know it's a bug .Anonymousnoreply@blogger.comtag:blogger.com,1999:blog-4677316190423110840.post-61099626851790280732012-10-19T10:54:28.534+02:002012-10-19T10:54:28.534+02:00Looks like this bug has been fixed in subsequent r...Looks like this bug has been fixed in subsequent releases of Oracle 11g ... tried it in 11.2.0.3 DB ... works flawlessly!Kannannoreply@blogger.comtag:blogger.com,1999:blog-4677316190423110840.post-24281226743572568812011-12-12T06:38:05.026+01:002011-12-12T06:38:05.026+01:00Thank you very much for describing the Continue Fu...Thank you very much for describing the Continue Functinality very beiefly. Thanks for letting us know the Bug. :)Venkathttps://www.blogger.com/profile/06342549561521926757noreply@blogger.comtag:blogger.com,1999:blog-4677316190423110840.post-41176190938513255672011-07-26T15:05:24.110+02:002011-07-26T15:05:24.110+02:00thank you! now i can sleep again.. :)thank you! now i can sleep again.. :)Martyhttps://www.blogger.com/profile/01961376592942533833noreply@blogger.comtag:blogger.com,1999:blog-4677316190423110840.post-90923729148840390472010-05-28T19:56:58.918+02:002010-05-28T19:56:58.918+02:00Thanks for this. I knew I wasn't crazy :-)Thanks for this. I knew I wasn't crazy :-)Doughttps://www.blogger.com/profile/15676540322334369535noreply@blogger.comtag:blogger.com,1999:blog-4677316190423110840.post-58266608076216920952009-04-13T16:01:00.000+02:002009-04-13T16:01:00.000+02:00THANK YOU VERY MUCH!!!You have seen this too!I wro...THANK YOU VERY MUCH!!!<BR/>You have seen this too!<BR/>I wrote:<BR/>declare <BR/> rowsCounter number(9) := 0;<BR/>begin<BR/> for r in ( select rownum rn from All_Objects where rownum <= 100 ) loop<BR/> rowsCounter := rowsCounter + 1;<BR/> dopl('rn=' || r.rn);<BR/> continue when mod(rowsCounter, 3) = 0;<BR/> end loop;<BR/> dopl('rowsCounter=' || rowsCounter);<BR/>end;<BR/><BR/>and... After 20 years of programming on wide range of langs I have opened the First Programmer Primer to learn about loops.<BR/><BR/>Uff! Thank you!Unknownhttps://www.blogger.com/profile/01892195379226591656noreply@blogger.comtag:blogger.com,1999:blog-4677316190423110840.post-25650215761030665642009-04-07T00:42:00.000+02:002009-04-07T00:42:00.000+02:00Nice warning. This would end up as one of those an...Nice warning. This would end up as one of those annoying things where some rows just appear to be randomly skipped (especially if the select didn't have an ORDER BY).<BR/>Wouldn't be surprised if, when run through a debugger, the plsql optimization is off and the issue doesn't reproduce.SydOraclehttps://www.blogger.com/profile/08828771074492585943noreply@blogger.comtag:blogger.com,1999:blog-4677316190423110840.post-26098444029143099142009-04-06T15:53:00.000+02:002009-04-06T15:53:00.000+02:00Bug id is 7306422 if you want to track this issue....Bug id is 7306422 if you want to track this issue.Paweł Baruthttps://www.blogger.com/profile/16867021334037413869noreply@blogger.comtag:blogger.com,1999:blog-4677316190423110840.post-63672058766081112502009-04-06T14:52:00.000+02:002009-04-06T14:52:00.000+02:00amazing! one more reason to Oracle V6 and never us...amazing! one more reason to Oracle V6 and never use new features!<BR/><BR/>thanks for sharing thisLaurent Schneiderhttps://www.blogger.com/profile/13833048234373264017noreply@blogger.com