Sunday Apr 29, 2012

Enabling trace in DBMS OUTPUT for HR APIs

While doing conversion,interface or any extension in HR sometime we have to debug the API to analyze the transaction flow.Below code snippet will be useful for such debugging (only for HR APIs).The below debug message we can view in the editor console itself.

Steps

1) Enable the DBMS OUTPUT.
2) EXEC DBMS_OUTPUT.ENABLE(1000000);
3) DECLARE
      ---
   BEGIN
      HR_UTILITY.SET_TRACE_OPTIONS('TRACE_DEST:DBMS_OUTPUT');
      HR_UTILITY.TRACE_ON(NULL, 'XX_TRACE') ;

      ----
      HR_UTILITY.TRACE_OFF;
   END;

About



Oracle Apps Technical Consultant,Bengaluru Area

Search

Categories
Archives
« April 2014
SunMonTueWedThuFriSat
  
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
   
       
Today