OracleAppsBlog

Thursday, June 17, 2004

Speeding up Oracle Hrms API debugging

One of my personal favorites is a little trick to speed up development and debugging of Oracle Hrms API’s.

The code behind the API’s has lots of trace statements. You can turn it on by calling “hr_utility.trace_on;”. But the output is now only available through a tool called PYUPIP. This is the one support asks many times for.

Just add one extra call to the previous one, and the trace messages are rerouted to dbms_output.

BEGIN
hr_utility.set_trace_options(’TRACE_DEST:DBMS_OUTPUT’);
hr_utility.trace_on;
END;

Page 1 of 1 pages