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 <Tim_at_SageLogix.com> 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: hamcdc_at_yahoo.co.uk
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: ListGuru_at_fatcity.com (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).
Received on Tue Dec 31 2002 - 05:54:00 CST
