Learn about Redwood and be one of the first to join the conversation

Visit Redwood Community
BI publisher variable not getting updated — Cloud Customer Connect
You're almost there! Please answer a few more questions for access to the Applications content. Complete registration
Interested in joining? Complete your registration by providing Areas of Interest here. Register

BI publisher variable not getting updated

Question
7
Views
0
Comments
edited Jul 9, 2021 8:49AM in Oracle Analytics

Summary

Variable PROCESSSTATUS is not getting updated,This is a BI stored procedure-to check the child jobs process status

Content

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;

Howdy, Stranger!

Log In

To view full details, sign in.

Register

Don't have an account? Click here to get started!