tag:blogger.com,1999:blog-15861274.post9046417030658760478..comments2023-09-18T11:14:24.509+01:00Comments on Oracle WTF: If at first you don't succeed...William Robertsonhttp://www.blogger.com/profile/06976436975493102341noreply@blogger.comBlogger11125tag:blogger.com,1999:blog-15861274.post-47930800747561476082012-03-20T22:01:10.092+00:002012-03-20T22:01:10.092+00:00The only reason I can see for coding
like this is ...The only reason I can see for coding<br />like this is if one is programming<br />against a blocking server like <br />SQLite - where only one user is allowed<br />access the database (1 file in this<br />case) at any given instant - so you<br />try 127 times - but since PL/SQL doesn't<br />work against SQLite (or is there something<br />I should be told?Pól Anaithnidhttps://www.blogger.com/profile/00039112080209001836noreply@blogger.comtag:blogger.com,1999:blog-15861274.post-62531647117293306372012-01-20T17:10:14.286+00:002012-01-20T17:10:14.286+00:00lololololollolololololmannihttps://www.blogger.com/profile/09131395615304252987noreply@blogger.comtag:blogger.com,1999:blog-15861274.post-40796665380292845242010-01-03T23:48:27.075+00:002010-01-03T23:48:27.075+00:00Fluff: put down the drink, and step away from the ...Fluff: put down the drink, and step away from the bar.Adrianhttps://www.blogger.com/profile/00943497054353493755noreply@blogger.comtag:blogger.com,1999:blog-15861274.post-216978944417752612009-12-31T20:43:52.752+00:002009-12-31T20:43:52.752+00:00Did this code come from forms? I have myself done ...Did this code come from forms? I have myself done things like that where they system can easily go into infinite loops and forms is one of those. I'm not going into details but there are some interpreted systems where it is exceedingly easy for the system to start looping. Typically some kind of reset or exception can trigger it. That causes people to put in loop stoppers like this. The underlying problem is the interpreter doesn't detect and stop loops. I wouldn't complain about it unless you like programs where the only way to halt a loop is to kill the whole thing and lose all your data.fluffhttps://www.blogger.com/profile/03044657181123647369noreply@blogger.comtag:blogger.com,1999:blog-15861274.post-17952004923325635022009-09-21T22:14:16.249+01:002009-09-21T22:14:16.249+01:00Who was it that said the definition of insanity is...Who was it that said the definition of insanity is performing the same action repeatedly and expecting different results?silentdhttps://www.blogger.com/profile/12837956374416719358noreply@blogger.comtag:blogger.com,1999:blog-15861274.post-88566833447821298042009-09-18T23:09:37.520+01:002009-09-18T23:09:37.520+01:00Ironically I formatted the code before posting so ...Ironically I formatted the code before posting so that irrelevant details wouldn't get in the way of the WTF. The original version looked like <a href="http://www.williamrobertson.net/documents/oracle_wtf_200909_get_id.sql" rel="nofollow">this</a>.William Robertsonhttps://www.blogger.com/profile/06976436975493102341noreply@blogger.comtag:blogger.com,1999:blog-15861274.post-1330748191599012822009-09-18T23:00:54.379+01:002009-09-18T23:00:54.379+01:00Welcome back Thai. Does this mean you'll be po...Welcome back Thai. Does this mean you'll be posting the one about the missing users and the other one about the telephone interview?William Robertsonhttps://www.blogger.com/profile/06976436975493102341noreply@blogger.comtag:blogger.com,1999:blog-15861274.post-68624993809629103772009-09-18T14:25:11.909+01:002009-09-18T14:25:11.909+01:00This technique must be gaining popularity.
I foun...This technique must be gaining popularity.<br /><br />I found similar code this morning, but in this case the perpetrator had managed to make it even less efficient by using an exception handler to recursively call the procedure (containing a MERGE) with an incrementing p_error_attempts parameter.Thai Riceshttps://www.blogger.com/profile/05276558737550243899noreply@blogger.comtag:blogger.com,1999:blog-15861274.post-669220112215078252009-09-18T11:02:11.574+01:002009-09-18T11:02:11.574+01:00commas in front with a tab. sheesh does no-one go ...commas in front with a tab. sheesh does no-one go to sqlchurch these days...Niallhttps://www.blogger.com/profile/07109750882834293686noreply@blogger.comtag:blogger.com,1999:blog-15861274.post-70392855519626719012009-09-02T17:22:29.395+01:002009-09-02T17:22:29.395+01:00Actually I formatted it a bit before posting. Than...Actually I formatted it a bit before posting. Thanks!<br /><br />Commas go in front, with one space. Everybody knows that.William Robertsonhttps://www.blogger.com/profile/06976436975493102341noreply@blogger.comtag:blogger.com,1999:blog-15861274.post-60978813165282076472009-09-02T17:04:42.785+01:002009-09-02T17:04:42.785+01:00at least it's pretty (ignoring the commas in f...at least it's pretty (ignoring the commas in front of course).oraclenerdhttps://www.blogger.com/profile/12412013306950057961noreply@blogger.com