BI publisher variable not getting updated
SummaryVariable PROCESSSTATUS is not getting updated,This is a BI stored procedure-to check the child jobs process status
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
type refcursor is REF CURSOR;