How to get the PYUPIP trace for APIs directly into DBMS_OUTPUT?
You can use the below commands to get the PYUPIP trace for APIs into DBMS output.
hr_utility.set_trace_options('TRACE_DEST:DBMS_OUTPUT');
hr_utility.trace_on;
<Here, you call your API>
--
-- Call the below command just after API call ends
--
hr_utility.trace_off;
For eg:
--
-- Your wrapper code
--
DECLARE
--
-- Variables declaration goes here..
--
BEGIN
--
-- Your code here..
--
...
...
--
-- Add the below commands just before calling the API
--
hr_utility.set_trace_options('TRACE_DEST:DBMS_OUTPUT');
hr_utility.trace_on;
HR_APPRAISALS_API.CREATE_APPRAISAL (
p_effective_date => TRUNC(SYSDATE),