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!
*********************************************************************This e-mail message is confidential, intended only for the named recipient(s) above and may contain information that is privileged, attorney work product or exempt from disclosure under applicable law. If you have received this message in error, or are not the named recipient(s), please immediately notify corporate MIS at (860) 766-2000 and delete this e-mail message from your computer, Thank you.*********************************************************************1
