Friday, June 18, 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;
e-mail this article • Modules • HRMS & Payroll • (3) Comments • Bookmark this to del.icio.us • Permalink