BI publisher variable not getting updated
Summary
Variable PROCESSSTATUS is not getting updated,This is a BI stored procedure-to check the child jobs process statusContent
This is a BI stored procedure which is to check the overall status - the child job status and respond, the initial query is to check for the status and in while condition the loop needs to be set as long as status is in running status.
The query and logic is working as expected only issues in with PROCESSSTATUS which is not getting updated, please advise
DECLARE
type refcursor is REF CURSOR;
xdo_cursor refcursor;
p_request_id varchar2(150):=:p_request_id;
0