Search 800 + Posts

Mar 6, 2019

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;

1 comment:

  1. Great Article Cloud Computing Projects

    Networking Projects

    Final Year Projects for CSE

    JavaScript Training in Chennai

    JavaScript Training in Chennai

    The Angular Training covers a wide range of topics including Components, Angular Directives, Angular Services, Pipes, security fundamentals, Routing, and Angular programmability. The new Angular TRaining will lay the foundation you need to specialise in Single Page Application developer. Angular Training

    ReplyDelete