RE: Tales Of Big Hammer #10046 (AKA event 10046)

Arup,  

Since I didn't see a line reporting error 1403, I was puzzled for a bit. But here is the application knowledge came handy. I should have see a commit for a successful operation. I didn't and instead saw a ROLLBACK. Immediately before the rollback I also saw a 'SQLNet Break' event so I put 2 and 2 togather and concluded that this caused the problem.  

when I looked up the code, this was a implicit cursor, so it basically confirmed that this was the culprit. Also we took the bind values and the statement from sqlplus, and it *did* return two rows.  

I highlighted the row with r=1 because according to Tim's explanation, I should have seen r=0. So I got confused and replied with excerpt from the tracefile. I know he will have some explanation about it.  

For rollback look at Cursor# 45 ...  

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!

-----Original Message-----
Sent: Tuesday, December 31, 2002 8:59 AM To: Multiple recipients of list ORACLE-L

Raj,  

Thanks for sharing this with us. In your original post you mentioned that you saw a "rollback" right after the "SQL*Net break/reset to client" and that was how you figured out the 1403 error. I don't see that in this excerpt from the raw trace file, though. How did you determine it was this particulat SQL? Also the FETCH#54 line you have highlighted has r=1, not r=0; what's special about that line?  

Thanks in advance.  

Arup

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