Brings to mind some of the great "hammer" quotes: "When all you have is a hammer, everything tends to look like a nail"
"When all you have is a hammer, maybe brain surgery is not for you" :-) Connor --- Tim Gorman <[EMAIL PROTECTED]> wrote: > Tales Of Big Hammer #10046 (AKA event > 10046)Generally you won't find "err=1403" text in > the raw ".trc" file. Instead, if you carefully > examine the FETCH lines, you'll see "r=0" (i.e. zero > rows returned) in amongst all the other statistics. > Very very difficult to catch and often requires a > Vulcan mind-meld to the application over several > hours of careful perusal (something best left to > Vulcans)... > > Great job! > ----- Original Message ----- > From: Jamadagni, Rajendra > To: Multiple recipients of list ORACLE-L > Sent: Monday, December 30, 2002 10:43 AM > Subject: Tales Of Big Hammer #10046 (AKA event > 10046) > > > On Friday our application support person called me > and said "User is getting a ORA-1403 error in one > form. I should mention that this is complex. And I > need a solution immediately." > > So, I gave them the hammer (with the sql string to > put in pre-form trigger in the form for the 546th > time, they never save their emails, especially from > a DBA). They set the event and ran the form. > > Now the entire support group recently had to face > me for an hour-long discussion on TKPROF (AKA the > Hammer) and debugging techniques, so they read the > tracefile and obediently tried to find a line with > 'ERR=1043' but couldn't find any. > > So I looked at the trace file, and sure it was, it > didn't show the error, but after one SQL it showed a > "'SQL*Net break/reset to client'" event followed by > a ROLLBACK. I directed them to that statement. This > person was happy that they found the culprit > statement, but couldn't find what was going wrong. > So they went through the presentation notes and used > "dbms_support.start_trace(true,true);" statement and > ran the form again. > > This time, as the trace dumped the bind values, > they found the set of values on which the query > returned 1403, and got back to the developer with a > solid case. > > So, once again ... if you have 10046 hammer, most > problems are like nails. > Raj > > ______________________________________________________ > > Rajendra Jamadagni MIS, ESPN Inc. > Rajendra dot Jamadagni at ESPN dot com > Any opinion expressed here is personal and doesn't > reflect that of ESPN Inc. > QOTD: Any clod can have facts, but having an > opinion is an art! > > ===== Connor McDonald http://www.oracledba.co.uk http://www.oaktable.net "GIVE a man a fish and he will eat for a day. But TEACH him how to fish, and...he will sit in a boat and drink beer all day" __________________________________________________ Do You Yahoo!? Everything you'll ever need on one web page from News and Sport to Email and Music Charts http://uk.my.yahoo.com -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: =?iso-8859-1?q?Connor=20McDonald?= INET: [EMAIL PROTECTED] Fat City Network Services -- 858-538-5051 http://www.fatcity.com San Diego, California -- Mailing list and web hosting services --------------------------------------------------------------------- To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
