Failed to get status: No process is associated with this object.

[sardarabdullahkhawar]

Hi all,

hope you are doing well. I have created a stored procedure in  oracle. Now i am trying to execute this stored procedure and schedule in Qlik Compose. I have made a sql file and put it here " <product_dir>\data\projects\YOUR_PROJECT\scripts" on the Compose server machine. This file contains executing statement of stored procedure

"BEGIN

DWH_PROD.Daily_Supply_PROC();

END;

/"

and when i amtrying to run this command task it says "Failed to get status: No process is associated with this object."

[sureshkumar]

Hello @sardarabdullahkhawar 

I would request you to kindly open a support ticket to understand the issue more.

Regards,

Suresh

[Dana_Baldwin]

Hi @sardarabdullahkhawar 

I agree with Suresh that a support case is probably needed for this, but it seems like you need a wrapper batch file that will initiate the sqlplus connection to Oracle.

Hope this helps,

Dana