Oracle-L: Tales Of Big Hammer #10046 (AKA event 10046)

From: Jamadagni, Rajendra <Rajendra.Jamadagni_at_espn.com>
Date: Mon, 30 Dec 2002 09:43:59 -0800
Message-ID: <F001.0052445F.20021230094359@fatcity.com>

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!

-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.net
-- 
Author: Jamadagni, Rajendra
  INET: Rajendra.Jamadagni_at_espn.com

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).



text/plain attachment: ESPN_Disclaimer.txt

Received on Mon Dec 30 2002 - 11:43:59 CST