AnsweredAssumed Answered

Display the result of stored procedure Output parameter from AFX connector

Question asked by Rajkiran Paul on Aug 28, 2020
Latest reply on Sep 1, 2020 by Mostafa Helmy

Hello,

 

We are using Oracle AFX connector for one of our Application provisioning/De-provisioning. Oracle connector is calling oracle stored procedure for provisioning/Processioning. 

 

Example:

CALL Oracle_SP(${user-id},${branch-id},${product-id},${flag},${message}). only parameter '${message}' is the output parameter. Stored procedure returns the result of execution as form of  Parameter '${message}'.

 

My question is how to read this output parameter in the connector after stored procedure is getting executed.We also want to display the result of stored procedure execution.

 

Product version : Aveksa 7.1.0 patch 8 

Outcomes