How to audit the execution of a proc

From: Peter Wu <peterwu_at_hotmail.com>
Date: Tue, 20 Apr 2004 13:24:34 -0400
Message-ID: <c63mcj$7ken2$1@ID-117651.news.uni-berlin.de>

In the production environment, there is a proc that runs daily. It runs successfully most of time but randomly fails with the following error message.

---

ERROR at line 1:
ORA-20000: PA_1000_KOI_DM - Create_KOI - -20000 - ORA-20000: PA_1000_KOI_DM -
Create_Billing_Readings - -20000 - ORA-20000: PA_1000_KOI_DM - Create_Billing_Services - -20000 - ORA-20000: pa_1000_koi_banner_rep - Retrieve_Registers - -2068 - ORA-02068: following seve

ORA-06512: at "REPORTS.PA_1000_KOI_DM", line 699
ORA-06512: at "REPORTS.PA_1000_KOI_DM", line 39
ORA-06512: at line 4


************************************************************************

My manager asks me to add some display statement in the proc to see where the failure is. What could be the good practice to trace the failure point during an execution of a proc?

The database is Oracle 8i running on Sun Solaris 8. Any input will be highly appreciated.

-- 
"Conceal a flaw, and the world will imagine the worst."
   - Marcus Valerius Martialis

Received on Tue Apr 20 2004 - 12:24:34 CDT