Share via

Azure Logic App with Oracle Stored Procedure Output Support

Kenny Kuntz 1 Reputation point
2021-06-29T18:41:51.74+00:00

I am using the Logic App connector to connect to Oracle and am trying to execute a Stored Procedure. It appears the connector is not currently supporting OUT parameters, ref cursors, etc.

So, how do I get result sets back from the Stored Proc into my Logic App? Or, when will return values/datasets be supported?

Azure Logic Apps
Azure Logic Apps
An Azure service that automates the access and use of data across clouds without writing code.
3,118 questions
0 comments

1 answer

Sort by: Most helpful
Most helpful Newest Oldest
  1. Pramod Valavala 20,626 Reputation points Microsoft Employee
    2021-06-30T13:10:57.297+00:00

    @Kenny Kuntz These are documented known issues and limitations. While there is no public road map, you can check Azure Updates for any updates.

    In the meantime, the workaround would be to leverage another service like Azure Functions which could trigger the stored procedure and return the result as required. You can call this function from the logic app.

    0 comments

Your answer

Answers can be marked as Accepted Answers by the question author, which helps users to know the answer solved the author's problem.